public MRMaterialCollec Get(long MRNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", MRNO)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRMaterial_By_MR", paramList);
MRMaterialCollec objMRMaterialCollec = new MRMaterialCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
MRMaterial objMRMaterial = new MRMaterial();
if (dt.Rows[i]["MRDescription"] != null)
{
objMRMaterial.Description = Convert.ToString(dt.Rows[i]["MRDescription"]);
}
if (dt.Rows[i]["MRMaterialCode"] != null)
{
objMRMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["MRMaterialCode"]));
}
if (dt.Rows[i]["MRNO"] != null)
{
objMRMaterial.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRNO"]));
}
objMRMaterial.MRBINNo = Convert.ToString(dt.Rows[i]["MRBINNo"]);
objMRMaterial.ReqdQty = Convert.ToDecimal(dt.Rows[i]["MRReqdQty"]);
objMRMaterial.IssuedQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]);
if (dt.Rows[i]["MRUnitRate"] != null)
{
objMRMaterial.UniRate = Convert.ToDecimal(dt.Rows[i]["MRUnitRate"]);
}
else
{
objMRMaterial.UniRate = 0;
}
objMRMaterial.Item = objMRMaterial.Material.MaterialCode + " - " + objMRMaterial.Material.MaterialDescription;
objMRMaterial.UnitCode = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["MRMaterialCode"])).MatUnit.UnitCode;
objMRMaterialCollec.Add(objMRMaterial);
}
return(objMRMaterialCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long GenerateMR(PRPDBatch objPRPD)
{
MR objMR = new MR();
MRMaterialCollec objMRMatCollec = new MRMaterialCollec();
MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec();
MRBasicProductCollec objMRBasicProductCollec = new MRBasicProductCollec();
BatchMR objBatchMR = new BatchMR();
Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection());
MR_DL objMRDL = new MR_DL(ConnectionStringClass.GetConnection());
MRMaterial_DL objMRMaterialDL = new MRMaterial_DL(ConnectionStringClass.GetConnection());
Store_DL objStoreDL = new Store_DL(ConnectionStringClass.GetConnection());
try
{
objMR.MRDate = DateTime.Now;
objMR.MRDepartmentFrom = objDepDL.GetByDepType("PRPD");
objMR.MREnterdBy = CurrentUser.EmployeeID;
objMR.MRStatus = MR.Status.Initial;
objMR.MRStore = objStore;
objMR.MRType = MR.Type.Material;
objMR.MRRemarks = "Material Requition(Materials) for PRPD Batch NO " + objPRPD.PRPDBatchID.ToString();
objMR.OriginType = MR.Origin.ToBatch;
MRMaterial obj = new MRMaterial();
obj.Description = "PRPD Batch Material Requition";
obj.Material = objPRPD.PRPDBatchMaterial;
obj.MRBINNo = "";
obj.ReqdQty = objPRPD.PRPDBatchQty;
long MRNO = objMRDL.Add_M(objMR);
if (MRNO > 0)
{
objMR.MRNO = MRNO;
obj.MR = objMR;
objMRMaterialDL.Add(obj);
}
return(MRNO);
}
catch (Exception ex)
{
return(0);
}
}
