public int InsertMaterialInward(List <EntityMatrialInword> lstentInward, EntityMatrialInword entMaterialInward) { int cnt = 0; List <string> lstspName = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); List <SqlParameter> lstParam; try { foreach (EntityMatrialInword entInward in lstentInward) { lstspName.Add("sp_InsertInwardDT"); lstParamVals.Add(CreateParameterMaterialInward(entInward)); lstParam = new List <SqlParameter>(); lstspName.Add("sp_UpdateItemByInwardDetails"); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entInward.ItemCode); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entInward.Quantity); lstParamVals.Add(lstParam); } if (!Commons.IsRecordExists("tblMaterialInwardMT", "InwardNo", entMaterialInward.InwardNo)) { lstspName.Add("sp_InsertInwardMT"); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@InwardNo", DbType.String, entMaterialInward.InwardNo); Commons.ADDParameter(ref lstParam, "@InwardDate", DbType.DateTime, entMaterialInward.InwardDate); Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entMaterialInward.SupplierCode); Commons.ADDParameter(ref lstParam, "@SupplierName", DbType.String, entMaterialInward.SupplierName); Commons.ADDParameter(ref lstParam, "@TotalInwardAmount", DbType.Decimal, entMaterialInward.TotalInwardAmount); Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entMaterialInward.EntryBy); lstParamVals.Add(lstParam); } lstParam = new List <SqlParameter>(); lstspName.Add("sp_UpdateSupplierMasterOnInward"); Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entMaterialInward.SupplierCode); Commons.ADDParameter(ref lstParam, "@InwardAmnt", DbType.Decimal, entMaterialInward.TotalInwardAmount); lstParamVals.Add(lstParam); cnt = mobjDataAcces.ExecuteTransaction(lstspName, lstParamVals); } catch (Exception ex) { Commons.FileLog("MterialInwardBLL - insertMaterialInward(EntityMatrialInward entMaterialInward)", ex); } return(cnt); }
public DataTable GetItemByGroup(EntityMatrialInword entInward) { DataTable ldt = new DataTable(); try { List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@GroupId", DbType.String, entInward.Group); ldt = mobjDataAcces.GetDataTable("sp_GetItemForInward", lstParam); } catch (Exception ex) { Commons.FileLog("MaterialInwardBLL - GetItem()", ex); } return(ldt); }
public int DeleteMaterialInward(List <EntityItem> lstentItemMaster, EntityMatrialInword entInward) { int cnt = 0; List <string> lstspName = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); List <SqlParameter> lstParam; try { lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@InwardNo", DbType.String, entInward.InwardNo); lstspName.Add("sp_DeleteInwardDT"); lstParamVals.Add(lstParam); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@InwardNo", DbType.String, entInward.InwardNo); lstspName.Add("sp_DeleteInwardMT"); lstParamVals.Add(lstParam); foreach (EntityItem entItemMaster in lstentItemMaster) { lstspName.Add("sp_UpdateItemByReqDetails"); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entItemMaster.ItemCode); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entItemMaster.OpeningBalance); lstParamVals.Add(lstParam); } lstParam = new List <SqlParameter>(); lstspName.Add("sp_UpdateSupplierMasterAmntOnInwardDelete"); Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entInward.SupplierCode); Commons.ADDParameter(ref lstParam, "@InwardAmnt", DbType.Decimal, entInward.TotalInwardAmount); lstParamVals.Add(lstParam); cnt = mobjDataAcces.ExecuteTransaction(lstspName, lstParamVals); } catch (Exception ex) { Commons.FileLog("MterialInwardBLL - DeleteMaterialInward(EntityMatrialInword entMaterialInward)", ex); } return(cnt); }
private List <SqlParameter> CreateParameterMaterialInward(EntityMatrialInword entInward) { List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@InwardNo", DbType.String, entInward.InwardNo); Commons.ADDParameter(ref lstParam, "@InwardDate", DbType.DateTime, entInward.InwardDate); Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entInward.SupplierCode); Commons.ADDParameter(ref lstParam, "@SupplierName", DbType.String, entInward.SupplierName); Commons.ADDParameter(ref lstParam, "@GroupId", DbType.Int32, entInward.Group); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entInward.ItemCode); Commons.ADDParameter(ref lstParam, "@ItemDesc", DbType.String, entInward.ItemDesc); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entInward.Quantity); Commons.ADDParameter(ref lstParam, "@UnitCode", DbType.String, entInward.unit); Commons.ADDParameter(ref lstParam, "@TotalAmount", DbType.Decimal, entInward.TotalAmount); Commons.ADDParameter(ref lstParam, "@OtherCharges", DbType.Decimal, entInward.OtherCharges); Commons.ADDParameter(ref lstParam, "@TotalProductAmount", DbType.Decimal, entInward.TotalProductAmount); Commons.ADDParameter(ref lstParam, "@TotalInwardAmount", DbType.Decimal, entInward.TotalInwardAmount); Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entInward.EntryBy); return(lstParam); }