private List <SqlParameter> createParameterList(EntityMaterialRequisition entRequisition) { List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entRequisition.ItemCode); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entRequisition.Qty); Commons.ADDParameter(ref lstParam, "@RequisitionStatus", DbType.String, entRequisition.RequisitionStatus); return(lstParam); }
private List <SqlParameter> CreateParameterMaterialReceipt(EntityMaterialRequisition entRequisition) { List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entRequisition.Qty); Commons.ADDParameter(ref lstParam, "@Unit", DbType.String, entRequisition.Unit); Commons.ADDParameter(ref lstParam, "@RequisitionBy", DbType.String, entRequisition.RequisitionBy); Commons.ADDParameter(ref lstParam, "@RequisitionStatus", DbType.String, entRequisition.RequisitionStatus); Commons.ADDParameter(ref lstParam, "@GroupId", DbType.Int32, entRequisition.Group); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entRequisition.ItemCode); Commons.ADDParameter(ref lstParam, "@ItemDesc", DbType.String, entRequisition.Item); Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entRequisition.EntryBy); return(lstParam); }
public DataTable GetItem(EntityMaterialRequisition entRequisition) { DataTable ldt = new DataTable(); try { List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@GroupId", DbType.String, entRequisition.Group); ldt = mobjDataAcces.GetDataTable("sp_GetItemForInward", lstParam); } catch (Exception ex) { Commons.FileLog("MaterialRequisitionBLL - GetItem()", ex); } return(ldt); }
public DataTable GetEmpName(EntityMaterialRequisition entRequisition) { DataTable ldt = new DataTable(); try { List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@EmpCode", DbType.String, entRequisition.EntryBy); ldt = mobjDataAcces.GetDataTable("sp_GetEmployeeName", lstParam); } catch (Exception ex) { Commons.FileLog("MaterialRequisitionBLL - GetUsername(EntityMaterialRequisition entRequisition)", ex); } return(ldt); }
public int DeleteRequisition(EntityMaterialRequisition entRequisition) { int cnt = 0; try { List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode); cnt = mobjDataAcces.ExecuteQuery("sp_DeleteRequisitionDT", lstParam); } catch (Exception ex) { Commons.FileLog("RequisitionBLL - DeleteRequisition(EntityRequisition entRequisition)", ex); } return(cnt); }
public int UpdateRequisition(List <EntityMaterialRequisition> pstentMaterialReq, EntityMaterialRequisition entRequisition) { int cnt = 0; List <string> lstspName = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); List <SqlParameter> lstParam; try { foreach (EntityMaterialRequisition entMaterialReq in pstentMaterialReq) { lstspName.Add("sp_UpdateRerquisitonDT"); lstParamVals.Add(createParameterList(entMaterialReq)); lstParam = new List <SqlParameter>(); lstspName.Add("sp_UpdateItemByReqDetails"); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entRequisition.ItemCode); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entRequisition.Qty); lstParamVals.Add(lstParam); } lstspName.Add("sp_UpdateRerquisitonMT"); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode); Commons.ADDParameter(ref lstParam, "@RequisitionStatus", DbType.String, entRequisition.RequisitionStatus); lstParamVals.Add(lstParam); cnt = mobjDataAcces.ExecuteTransaction(lstspName, lstParamVals); } catch (Exception ex) { Commons.FileLog("RequisitionDetailsBLL - InsertRequisition(EntityRequisition entRequisition)", ex); } return(cnt); }
public int InsertRequisition(List <EntityMaterialRequisition> lstentRequisition, EntityMaterialRequisition entRequisition) { int cnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); try { foreach (EntityMaterialRequisition entMaterialReq in lstentRequisition) { lstspNames.Add("sp_InsertRequisitionDT"); lstParamVals.Add(CreateParameterMaterialReceipt(entMaterialReq)); } if (!Commons.IsRecordExists("tblMaterialRequisitionMT", "RequisitionCode", entRequisition.RequisitionCode)) { lstspNames.Add("sp_InsertRequisitionMT"); List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode); Commons.ADDParameter(ref lstParam, "@RequisitionBy", DbType.String, entRequisition.RequisitionBy); Commons.ADDParameter(ref lstParam, "@RequisitionStatus", DbType.String, entRequisition.RequisitionStatus); Commons.ADDParameter(ref lstParam, "@GroupId", DbType.Int32, entRequisition.Group); Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entRequisition.EntryBy); lstParamVals.Add(lstParam); } cnt = mobjDataAcces.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { Commons.FileLog("CustomerReceiptBLL - InsertRequisitionDT(List<EntityMaterialRequisition> lstentRequisition, EntityMaterialRequisition entRequisition)", ex); } return(cnt); }