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); } }
public void Load_Data(SqlConnection Conn, string MatCode) { objMaterial_DL = new Material_DL(Conn); objStore_DL = new Store_DL(Conn); objDepartment_DL = new Department_DL(Conn); BasicMaterialCode = MatCode; objMaterial = objMaterial_DL.GetProcessdMaterial(BasicMaterialCode); if (objMaterial != null) { textBox1.Text = objMaterial.MaterialNameCode; //cmbStoreTo.DataSource = objStore_DL.GetData(); //cmbStoreTo.SelectedValue = objStore_DL.Get_Default(objDepartment_DL.GetByDepType("Store").DepID).StoreID; //cmbStoreTo.Enabled = true; } else { //cmbStoreTo.Enabled = false; textBox1.Text = "N/A"; } }