public List<Supplier> GetSuppliersMatchingFullName(string str)
{
try
{
List<Supplier> supplierList = null;
var supppliers = from s in dc.tblSuppliers
where s.supplierName.StartsWith(str) && s.supplierStatus.ToUpper() != "BLOCK"
select s;
if (null != supppliers && supppliers.Count() > 0)
{
supplierList = new List<Supplier>();
foreach (tblSupplier s in supppliers)
{
Supplier sup = new Supplier();
sup.supplierId = s.supplierId;
sup.supplierName = s.supplierName;
sup.supplierStatus = s.supplierStatus;
sup.supplierContactNumber = s.supplierContactNo;
sup.supplierAddress = s.supplierAddress;
supplierList.Add(sup);
}
}
return supplierList;
}
catch (Exception ex)
{
throw ex;
}
}
private void getTableSupplierEquivalentFromSupplierEntity(ref tblSupplier tblSupplierObj, Supplier s)
{
try
{
tblSupplierObj.supplierName = s.supplierName;
tblSupplierObj.supplierStatus = s.supplierStatus;
tblSupplierObj.supplierContactNo = s.supplierContactNumber;
tblSupplierObj.supplierAddress = s.supplierAddress;
}
catch (Exception ex)
{
throw ex;
}
}
public void AddSupplier(Supplier s)
{
try
{
tblSupplier tblSupplierObj = new tblSupplier();
getTableSupplierEquivalentFromSupplierEntity(ref tblSupplierObj, s);
dc.tblSuppliers.InsertOnSubmit(tblSupplierObj);
dc.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
private void GetCorrespondingtblSupplierFromSupplier(ref tblSupplier sup, Supplier _SupplierTobeEdited)
{
//return new tblSupplier
//{
sup.supplierId = (int)_SupplierTobeEdited.supplierId;
sup.supplierName = _SupplierTobeEdited.supplierName;
sup.supplierStatus = _SupplierTobeEdited.supplierStatus;
sup.supplierContactNo = _SupplierTobeEdited.supplierContactNumber;
sup.supplierAddress = _SupplierTobeEdited.supplierAddress;
//};
}
public void UpdateSupplierDetails(Supplier _SupplierTobeEdited)
{
//tblSupplier updated = GetCorrespondingtblSupplierFromSupplier(_SupplierTobeEdited);
tblSupplier toBeUpdated = (from s in dc.tblSuppliers
where s.supplierId == _SupplierTobeEdited.supplierId
select s).FirstOrDefault();
GetCorrespondingtblSupplierFromSupplier(ref toBeUpdated, _SupplierTobeEdited);
dc.SubmitChanges();
}
private void BindSupplierToRespectiveFields(Supplier s)
{
//txtFullName.Text = s.supplierName;
//txtContactNo1.Text = s.supplierContactNumber;
//txtAddress.Text = s.supplierAddress;
//cboSupplierStatus.Text = s.supplierStatus;
}