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);
}
