public static bool IsVendorModified(BO_Vendor Uiobject, ApprosysAccDB.Vendor dbobject)
{
bool res = false;
if (Uiobject.firstName != dbobject.FirstName)
{
res = true;
}
return(res);
if (Uiobject.lastName != dbobject.LastName)
{
res = true;
}
return(res);
if (Uiobject.phone != dbobject.Phone)
{
res = true;
}
return(res);
if (Uiobject.email != dbobject.Email)
{
res = true;
}
return(res);
return(res);
}
public static string SaveVendor(BO_Vendor _vendor, int userId)
{
using (AprosysAccountingEntities db = new AprosysAccountingEntities())
{
try
{
//var objcheck = db.Vendors.Where(x => x.LastName.ToLower() == _vendor.lastName.ToLower() && x.FirstName.ToLower() == _vendor.firstName.ToLower()).FirstOrDefault();
//if (objcheck != null)
//{
// return "Vendor Already Exists";
//}
var obj = _vendor.id == 0 ? new ApprosysAccDB.Vendor() : db.Vendors.Where(x => x.ID == _vendor.id && x.IsActive == true).FirstOrDefault();
//bool isVendorModified = false;
// if (obj != null && obj.ID > 0) { isVendorModified = IsVendorModified(_vendor, obj); }
if (_vendor.id > 0)
{
var checkCust = db.Vendors.Where(x => x.LastName.ToLower() == _vendor.lastName.ToLower() && x.FirstName.ToLower() == _vendor.firstName.ToLower() && x.ID != _vendor.id && x.IsActive == true).FirstOrDefault();
if (checkCust != null)
{
return("Vendor Already Exists");
}
}
if (obj != null && obj.ID > 0)
{
obj.ModifiedBy = userId;
obj.ModifiedOn = BL_Common.GetDatetime();
}
obj.ID = _vendor.id;
obj.LastName = _vendor.lastName;
obj.FirstName = _vendor.firstName;
obj.Phone = _vendor.phone ?? "";
obj.Email = _vendor.email;
obj.Terms = _vendor.terms;
obj.CreditLimit = _vendor.creditLimit;
obj.Balance = _vendor.balance;
obj.Misc = _vendor.misc;
obj.IsActive = true;
obj.CNIC = _vendor.cnic;
obj.NTN = _vendor.ntn;
if (obj.ID == 0)
{
obj.CreatedBy = userId;
obj.CreatedOn = BL_Common.GetDatetime();
var objcheck = db.Vendors.Where(x => x.LastName.ToLower() == _vendor.lastName.ToLower() && x.FirstName.ToLower() == _vendor.firstName.ToLower() && x.IsActive == true).FirstOrDefault();
if (objcheck != null)
{
return("Vendor Already Exists");
}
db.Vendors.Add(obj);
}
db.SaveChanges();
return("success");
// return "Insertion Failed";
}
catch { throw; }
}
}
