Checking if record exist (entity framework)

Peter Dzuya

Hi Experts I am new to C#. I have a Form that add new a customer . But I want to check if that customer already exist. How do I do it from the the code shown here below. Thanks

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Linq;

using System.Threading.Tasks;

using System.Windows.Forms;

using DevExpress.XtraBars.Alerter;

using DevExpress.XtraEditors;

using MakGarm.Business;

using MakGarm.Business.Contracts;

using MakGarm.Common.Entities.Core;

using MakGarm.Common.Entities.GeneralLedgerAccounts;

using MakGarm.Common.Entities.Miscellaneous;

using MakGarm.Common.Entities.SubsidiaryLedgerAccounts;

using Microsoft.Practices.Unity;

using Uwapi.Utils;

namespace MakGarm.Start.Customers {

public partial class frmAddCustomer : DevExpress.XtraEditors.XtraForm {

private readonly ICustomerService _customerService;

private readonly Customer _customer;

private readonly IContactService _contactService;

private readonly IFinancialMonthService _financialMonthService;

private readonly FinancialYear _financialYear;

public int NewcontactId;

public int CheckCustomerId;

public frmAddCustomer() {

InitializeComponent();

_customerService = UnityConfig.GetContainer().Resolve();

_contactService = UnityConfig.GetContainer().Resolve();

_financialMonthService = UnityConfig.GetContainer().Resolve();

_customer = new Customer() {

Active = true,

Accountclosed = false,

Datecreated = DateTime.Now,

CreditDays = 0,

CreditLimit = 0,

LastEditedDate = DateTime.Now,

CompanyBranchId = CurrentUserInfo.User.CompanyBranch.CompanyId,

CheckerUserId = CurrentUserInfo.User.UserId,

LastEditorUserId = CurrentUserInfo.User.UserId,

};

}

private void frmAddCustomer_Load(object sender, EventArgs e){

customerBindingSource.DataSource = _customer;

ContactBindingSource.DataSource = _contactService.GetAll();

FinacialMonthsbindingSource.DataSource = _financialMonthService.GetCurrentFinancialMonth();

}

private void simpleButtonAcccept_Click(object sender, EventArgs e){

_customer.ContactId = NewcontactId;

_customer.BillingStartFinancialMonthId = _financialMonthService.GetCurrentFinancialMonth().FinancialMonthId;

customerBindingSource.EndEdit();

_customerService.Insert(_customer);

AlertButton Btn = new AlertButton();

Btn.Hint = "Open File";

Btn.Name = "Button Open";

alertControl1.Buttons.Add(Btn);

alertControl1.ButtonClick += new AlertButtonClickEventHandler(alertControl1_ButtonClick);

AlertInfo info = new AlertInfo("GMIS 2015 Alert",

"The new job card record has been Added successfully");

alertControl1.Show(this, info);

this.Close();

}

private void alertControl1_ButtonClick(object sender, AlertButtonClickEventArgs e) {

throw new NotImplementedException();

}

private void contactNameSearchLookUpEdit_EditValueChanged(object sender, EventArgs e){

var selectedContact = contactNameSearchLookUpEditView.GetFocusedRow() as Contact;

if (selectedContact == null) return;

NewcontactId = selectedContact.ContactId;

}

private void simpleButtonCancel_Click(object sender, EventArgs e) {

if(MessageBox.Show("Do you really want to cancel this process","GMIS - Cancel",MessageBoxButtons.YesNo,MessageBoxIcon.Question)==DialogResult.Yes) {

contactNameSearchLookUpEdit.Text = string.Empty;

remarksMemoEdit.Text = string.Empty;

}

private void simpleButtonClose_Click(object sender, EventArgs e) {

if (MessageBox.Show("Are You sure", "GMIS - Close", MessageBoxButtons.YesNo, MessageBoxIcon.Question) ==

DialogResult.Yes) {

this.Close();

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Maruthi11y ago
Accepted answer
Hi Peter,

Please give a try as below:

private void simpleButtonAcccept_Click(object sender, EventArgs e){

_customer.ContactId = NewcontactId;
_customer.BillingStartFinancialMonthId = _financialMonthService.GetCurrentFinancialMonth().FinancialMonthId;

customerBindingSource.EndEdit();
bool isexists = db.customers.Any( x =>x.ContactId == _customer.ContactId)

if(!isexists)
{
_customerService.Insert(_customer);
AlertButton Btn = new AlertButton();
Btn.Hint = "Open File";
Btn.Name = "Button Open";
alertControl1.Buttons.Add(Btn);
alertControl1.ButtonClick += new AlertButtonClickEventHandler(alertControl1_ButtonClick);
AlertInfo info = new AlertInfo("GMIS 2015 Alert",
"The new job card record has been Added successfully");
alertControl1.Show(this, info);

this.Close();
}

else
{
throw new MoreDescriptiveException("Customer Exists Already In Db");

}

}
+1
Ramesh Maruthi11y ago
No problem Peter, Good to hear your problem has been solved :)
+1
Peter Dzuya11y ago
Thank you So Much Mr Maresh Maruthi. You made my day. I did a bit of adjust as shown below and it worked very well.

private void simpleButtonAcccept_Click(object sender, EventArgs e){
try {
_customer.ContactId = NewcontactId;
_customer.BillingStartFinancialMonthId = _financialMonthService.GetCurrentFinancialMonth().FinancialMonthId;

customerBindingSource.EndEdit();

var selectedcontact = _contactService.GetAll();
bool isexists = selectedcontact.Any(x => x.ContactId == _customer.ContactId);

if (!isexists) {
_customerService.Insert(_customer);
AlertButton Btn = new AlertButton();
Btn.Hint = "Open File";
Btn.Name = "Button Open";
alertControl1.Buttons.Add(Btn);
alertControl1.ButtonClick += new AlertButtonClickEventHandler(alertControl1_ButtonClick);
AlertInfo info = new AlertInfo("GMIS 2015 Alert",
"The new customer record has been Added successfully");
alertControl1.Show(this, info);
this.Close();
}

else {

MessageBox.Show("The selected contact already exists as a customer", "GMIS - Error",
MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

} catch (UwapiValidationException ex) {
string errorMessage = "Please fix the issue below before Proceeding:";
int i = 0;
foreach (var error in ex.Errors) errorMessage += string.Format("\n{0}) {1}", ++i, error.Message);
MessageBox.Show(errorMessage, "Could not save record", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
} catch (Exception ex) {
MessageBox.Show(ex.GetBaseException().Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}

Thank once again.
0
Shuvojit Halder11y ago
You can check this way

try
{
var isExist=db.Customer.where(a=>a.Field1=YourInputvalue1 && a.Field2=YourInputvalue2).FirstOrDefault();

if (isExist==null)
{
// your insert code
}
else
{
}
}
catch
{
}
+1