public PRPDActivityDetailsLabour Get(long ActivityDetailsLabourID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@ActivityDetailsLabourID", ActivityDetailsLabourID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDActivityDetailsLabourByID", paramList); PRPDActivityDetailsLabour obj = new PRPDActivityDetailsLabour(); if (dt.Rows.Count > 0) { obj.ActivityDetailsLabourID = Convert.ToInt64(dt.Rows[0]["ActivityDetailsLabourID"]); obj.PRPDBatchActivityDetails = Convert.ToInt64(dt.Rows[0]["BatchActID"]); obj.Helper = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["Helper"])); obj.StartTime_D = Convert.ToDateTime(dt.Rows[0]["StartTime"]); obj.StopTime_D = Convert.ToDateTime(dt.Rows[0]["StopTime"]); obj.OTHours = Convert.ToDecimal(dt.Rows[0]["OTHours"]); obj.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]); obj.HourlyRate = Convert.ToDecimal(dt.Rows[0]["HourlyRate"]); obj.OTRate = Convert.ToDecimal(dt.Rows[0]["OTRate"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Store Get_Default(long DepID) { Department_DL objDep_DL = new Department_DL(Connection); Employee_DL objEmp_DL = new Employee_DL(Connection); Store objStore = new Store(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@StoreDepID", DepID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Store_Default", paramList); objStore.StoreDepartment = objDep_DL.Get(Convert.ToInt64(dt.Rows[0]["StoreDepID"])); objStore.StoreDescription = Convert.ToString(dt.Rows[0]["StoreDesription"]); objStore.StoreID = Convert.ToString(dt.Rows[0]["StoreID"]); objStore.StoreKeeper = objEmp_DL.Get(Convert.ToString(dt.Rows[0]["StoreKeeper"])); objStore.StoreName = Convert.ToString(dt.Rows[0]["StoreName"]); return(objStore); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public SectionsCollec Get() { Employee_DL objEmployee_DL = new Employee_DL(Connection); SectionsCollec objSectionsCollec = new SectionsCollec(); try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Section"); for (int i = 0; i < dt.Rows.Count; i++) { Sections objSections = new Sections(); objSections.DepID = Convert.ToInt64(dt.Rows[i]["DepID"]); objSections.SectionHead = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["SuperviserID"])); objSections.SectionName = Convert.ToString(dt.Rows[i]["SectionName"]); objSections.SectionID = Convert.ToInt64(dt.Rows[i]["SectionID"]); objSectionsCollec.Add(objSections); } return(objSectionsCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Sections Get(long SectionID) { Employee_DL objEmployee_DL = new Employee_DL(Connection); SectionsCollec objSectionsCollec = new SectionsCollec(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@SectionID", SectionID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Section_By_ID", paramList); Sections objSections = new Sections(); if (dt.Rows.Count > 0) { objSections.DepID = Convert.ToInt64(dt.Rows[0]["DepID"]); objSections.SectionHead = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["SuperviserID"])); objSections.SectionName = Convert.ToString(dt.Rows[0]["SectionName"]); objSections.SectionID = Convert.ToInt64(dt.Rows[0]["SectionID"]); } return(objSections); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public UserCollec Get() { UserCollec objUserCollec = new UserCollec(); Employee_DL objEmpDL = new Employee_DL(Connection); try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_User"); for (int i = 0; i < dt.Rows.Count; i++) { User objUser = new User(); objUser.UserAnswer = Convert.ToString(dt.Rows[i]["Answer"]); objUser.UserEmp = objEmpDL.Get(Convert.ToString(dt.Rows[i]["EmpID"])); objUser.UserID = Convert.ToInt64(dt.Rows[i]["UserID"]); objUser.UserName = Convert.ToString(dt.Rows[i]["UserName"]); objUser.UserPassword = Convert.ToString(dt.Rows[i]["Password"]); objUser.UserQuestion = Convert.ToString(dt.Rows[i]["Question"]); objUser.UserStatus = Convert.ToBoolean(dt.Rows[i]["Status"]); objUser.UserRoleID = Convert.ToInt64(dt.Rows[i]["UserRoleID"]); objUserCollec.Add(objUser); } return(objUserCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DeliverNote Get(string DeliverNoteID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DeliverNoteNo", DeliverNoteID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_DeliverNoteNoByID", paramList); DeliverNote obj = new DeliverNote(); if (dt.Rows.Count > 0) { obj.DeleveryNoteID = Convert.ToString(dt.Rows[0]["DeliverNoteNo"]); obj.DeleveryNoteEnterdBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["DeliverEnterdBy"])); obj.DeleveryNoteDate = Convert.ToDateTime(dt.Rows[0]["DeliverDate"]); obj.DeleveryNoteEnterdDate = Convert.ToDateTime(dt.Rows[0]["DeliverEnterdDate"]); obj.DeleveryNotePO = Convert.ToString(dt.Rows[0]["DeliverPONO"]); obj.DeleveryNoteStatus = (DeliverNote.Status)(dt.Rows[0]["Status"]); obj.Supplier = Convert.ToInt64(dt.Rows[0]["SupplierCode"]); obj.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public User Get(long UserID) { User objUser = new User(); Employee_DL objEmpDL = new Employee_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@UserID", UserID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_UserByID"); objUser.UserAnswer = Convert.ToString(dt.Rows[0]["Answer"]); objUser.UserEmp = objEmpDL.Get(Convert.ToString(dt.Rows[0]["EmpID"])); objUser.UserID = Convert.ToInt64(dt.Rows[0]["UserID"]); objUser.UserName = Convert.ToString(dt.Rows[0]["UserName"]); objUser.UserPassword = Convert.ToString(dt.Rows[0]["Password"]); objUser.UserQuestion = Convert.ToString(dt.Rows[0]["Question"]); objUser.UserStatus = Convert.ToBoolean(dt.Rows[0]["Status"]); objUser.UserRoleID = Convert.ToInt64(dt.Rows[0]["UserRoleID"]); return(objUser); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public BatchLabourDetails Get(long LabourActID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@LabourRecID", LabourActID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_BatchLaourDetails", paramList); BatchLabourDetails obj = new BatchLabourDetails(); BatchActivity_DL objBatchActivity_DL = new BatchActivity_DL(ConnectionStringClass.GetConnection()); Employee_DL objEmployee_DL = new Employee_DL(ConnectionStringClass.GetConnection()); if (dt.Rows.Count != 0) { obj.BatchAct = objBatchActivity_DL.GetByID(Convert.ToInt32(dt.Rows[0]["BatchActID"])); obj.Emp = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["EmployeeID"])); obj.HourlyRate = Convert.ToDecimal(dt.Rows[0]["HourlyRate"]); obj.LabourRecID = Convert.ToInt32(dt.Rows[0]["LabourRecID"]); obj.OTHours = Convert.ToDecimal(dt.Rows[0]["OTHours"]); obj.OTRate = Convert.ToDecimal(dt.Rows[0]["OTRate"]); obj.WorkStart_Date = Convert.ToDateTime(dt.Rows[0]["WorkStart"]); obj.WorkStop_Date = Convert.ToDateTime(dt.Rows[0]["WorkStop"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
//public int Add(TGRN obj) //{ // tblTGRNTableAdapter da = new tblTGRNTableAdapter(); // da.Connection = Connection; // try // { // return da.Insert(obj.TGRNDeleveryNote.DeleveryNoteID, // obj.TGRNDate, // obj.TGRNEnterdBy.EmployeeID, // Convert.ToInt32(obj.TGRNStatus)); // } // catch (Exception ex) // { // throw new Exception(ex.Message, ex); // } // finally // { // da.Dispose(); // } //} //public int Update(TGRN obj) //{ // tblTGRNTableAdapter da = new tblTGRNTableAdapter(); // da.Connection = Connection; // try // { // return da.Update(obj.TGRNDeleveryNote.DeleveryNoteID, // obj.TGRNDate, // obj.TGRNEnterdBy.EmployeeID, // Convert.ToInt32(obj.TGRNStatus), // obj.TGRNNO); // } // catch (Exception ex) // { // throw new Exception(ex.Message, ex); // } // finally // { // da.Dispose(); // } //} //public int Delete(long TGRNNO) //{ // tblTGRNTableAdapter da = new tblTGRNTableAdapter(); // da.Connection = Connection; // try // { // return da.Delete(TGRNNO); // } // catch (Exception ex) // { // throw new Exception(ex.Message, ex); // } // finally // { // da.Dispose(); // } //} //public TGRNCollec Get() //{ // tblTGRNTableAdapter da = new tblTGRNTableAdapter(); // da.Connection = Connection; // Employee_DL objEmpDL = new Employee_DL(Connection); // DeleverNote_DL objDelNoteDL = new DeleverNote_DL(Connection); // TGRNCollec objTGRNCollec = new TGRNCollec(); // MRPDataSet1 dsMRP = new MRPDataSet1(); // try // { // da.Fill(dsMRP.tblTGRN); // foreach (MRPDataSet1.tblTGRNRow dr in dsMRP.tblTGRN) // { // TGRN objTGRN = new TGRN(); // objTGRN.TGRNDate = dr.TGRNDate; // objTGRN.TGRNDeleveryNote = objDelNoteDL.Get(dr.TGRNDeleverNoteNo); // objTGRN.TGRNEnterdBy = objEmpDL.Get(dr.TGRNEnterdBy); // objTGRN.TGRNEnterdDate = dr.TGRNEnterdDate; // objTGRN.TGRNNO = Convert.ToInt64(dr.TGRNNO); // objTGRN.TGRNStatus = (TGRN.Status)Convert.ToInt32(dr.TGRNStatus); // objTGRNCollec.Add(objTGRN); // } // return objTGRNCollec; // } // catch (Exception ex) // { // throw new Exception(ex.Message, ex); // } // finally // { // da.Dispose(); // } //} public TGRN Get(long TGRNNO) { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@TGRNNo", TGRNNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_TGRNByID", paramList); TGRN obj = new TGRN(); try { if (dt.Rows.Count > 0) { obj.TGRNDate = Convert.ToDateTime(dt.Rows[0]["TGRNDate"]); obj.TGRNDeleveryNote = objDeliverNote_DL.Get(Convert.ToString(dt.Rows[0]["TGRNDeleverNoteNo"])); obj.TGRNEnterdBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["TGRNEnterdBy"])); obj.TGRNEnterdDate = Convert.ToDateTime(dt.Rows[0]["TGRNEnterdDate"]); obj.TGRNNO = Convert.ToInt64(dt.Rows[0]["TGRNNO"]); obj.TGRNStatus = (TGRN.Status)Convert.ToInt32(dt.Rows[0]["TGRNStatus"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { } }
public Formula Get(long FormulaID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@FormulaID", FormulaID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Formula", paramList); Formula obj = new Formula(); if (dt.Rows.Count > 0) { obj.FormulaID = Convert.ToInt64(dt.Rows[0]["FormulaID"]); obj.FormulaInstructedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["FormulaInstructedBy"])); obj.FormulaInstructedDate = Convert.ToDateTime(dt.Rows[0]["FormulaInstructedDate"]); obj.FormulaQty = Convert.ToInt64(dt.Rows[0]["FormulaQty"]); obj.FormulaUnit = objUnit_DL.Get(Convert.ToInt64(dt.Rows[0]["FormulaUnitID"])); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public StoreCollec Get() { Department_DL objDep_DL = new Department_DL(Connection); Employee_DL objEmp_DL = new Employee_DL(Connection); StoreCollec objStoreCollec = new StoreCollec(); try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Store"); for (int i = 0; i < dt.Rows.Count; i++) { Store objStore = new Store(); objStore.StoreDepartment = objDep_DL.Get(Convert.ToInt64(dt.Rows[i]["StoreDepID"])); objStore.StoreDescription = Convert.ToString(dt.Rows[i]["StoreDesription"]); objStore.StoreID = Convert.ToString(dt.Rows[i]["StoreID"]); objStore.StoreKeeper = objEmp_DL.Get(Convert.ToString(dt.Rows[i]["StoreKeeper"])); objStore.StoreName = Convert.ToString(dt.Rows[i]["StoreName"]); objStoreCollec.Add(objStore); } return(objStoreCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public MTNCollec Get(long FromDepID, MTN.Status Status) { Employee_DL objEmployee_DL = new Employee_DL(Connection); Department_DL objDepartment_DL = new Department_DL(Connection); MTNCollec objMTNCollec = new MTNCollec(); Store_DL objStore_DL = new Store_DL(Connection); GRN_DL objGRN_DL = new GRN_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DepID", FromDepID), new SqlParameter("@MTNStatus", Status) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_ByFromDep_Status", paramList); for (int i = 0; i < dt.Rows.Count; i++) { MTN objMTN = new MTN(); objMTN.MTNApprovedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNApprovedBy"])); objMTN.MTNApprovedDate = Convert.ToDateTime(dt.Rows[i]["MTNApproveDate"]); objMTN.MTNBatch = "No"; objMTN.MTNDate = Convert.ToDateTime(dt.Rows[i]["MTNDate"]); objMTN.MTNDepartmentFrom = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[i]["MTNFromDepID"])); objMTN.MTNDepartmentTo = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[i]["MTNToDepID"])); objMTN.MTNEnterdBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNEnterdBy"])); objMTN.MTNNo = Convert.ToInt64(dt.Rows[i]["MTNNo"]); objMTN.MTNReceivedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNReceivedBy"])); objMTN.MTNReceivedDate = Convert.ToDateTime(dt.Rows[i]["MTNReceivedDate"]); objMTN.MTNStatus = (MTN.Status)dt.Rows[i]["MTNStatus"]; objMTN.MTNType = (MTN.Type)dt.Rows[i]["MTNType"]; objMTN.MTNItemType = (MTN.ItemType)dt.Rows[i]["MTNItemType"]; objMTN.MTNStore = objStore_DL.Get(Convert.ToString(dt.Rows[i]["MTNStore"])); objMTNCollec.Add(objMTN); } return(objMTNCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public BatchActivity Get(string BatchID, long ActID) { BatchActivity objBatchActivity = new BatchActivity(); Batch_DL objBatch_DL = new Batch_DL(Connection); Employee_DL objEmployee_DL = new Employee_DL(Connection); MainActivity_DL objMainActivity_DL = new MainActivity_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@ActID", ActID), new SqlParameter("@BatchID", BatchID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_BatchActivity_By_Batch_Act", paramList); if (dt.Rows.Count != 0) { objBatchActivity.MainActivity = objMainActivity_DL.Get(Convert.ToInt64(dt.Rows[0]["ActID"])); objBatchActivity.BatchActID = Convert.ToInt64(dt.Rows[0]["BatchActID"]); objBatchActivity.Batch = objBatch_DL.Get(dt.Rows[0]["BatchID"].ToString()); objBatchActivity.BatchActStatus = (BatchActivity.Status)dt.Rows[0]["BatchActStatus"]; if (dt.Rows[0]["SequenceNo"] != DBNull.Value) { objBatchActivity.SequenceNo = Convert.ToInt32(dt.Rows[0]["SequenceNo"]); } objBatchActivity.Part = dt.Rows[0]["Part"].ToString(); objBatchActivity.LastEdited = Convert.ToDateTime(dt.Rows[0]["LastEdited"]); objBatchActivity.BlockNextActivity = Convert.ToBoolean(dt.Rows[0]["BlockNextActivity"]); objBatchActivity.ActMethod = Convert.ToString(dt.Rows[0]["ActMethod"]); if (dt.Rows[0]["StartQty"] != DBNull.Value) { objBatchActivity.StartQty = Convert.ToDecimal(dt.Rows[0]["StartQty"]); } if (dt.Rows[0]["StopQty"] != DBNull.Value) { objBatchActivity.StopQty = Convert.ToDecimal(dt.Rows[0]["StopQty"]); } if (dt.Rows[0]["SupervisedBy"] != DBNull.Value) { objBatchActivity.SupervisedBy = objEmployee_DL.Get(dt.Rows[0]["SupervisedBy"].ToString()); } } return(objBatchActivity); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public PRPDCAP Get(long PRPDCAPID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDCAPID", PRPDCAPID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDCAPByID", paramList); PRPDCAP obj = new PRPDCAP(); if (dt.Rows.Count > 0) { obj.PRPDCAPID = Convert.ToInt64(dt.Rows[0]["PRPDCAPID"]); obj.MaterialCode = Convert.ToString(dt.Rows[0]["CAPMaterial"]); obj.GRNNO = Convert.ToInt64(dt.Rows[0]["GRNNO"]); obj.CAPQty = Convert.ToDecimal(dt.Rows[0]["CAPQty"]); obj.Instructions = Convert.ToString(dt.Rows[0]["Instructions"]); obj.ReworkQty = Convert.ToDecimal(dt.Rows[0]["ReworkQty"]); obj.DisposeQty = Convert.ToDecimal(dt.Rows[0]["DisposeQty"]); obj.AcceptQty = Convert.ToDecimal(dt.Rows[0]["AcceptQty"]); obj.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]); obj.EnteredBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["EnterdBy"])); obj.EnteredDate = Convert.ToDateTime(dt.Rows[0]["EnterdDate"]); obj.ApprovedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["ApprovedBy"])); obj.ApprovedDate = Convert.ToDateTime(dt.Rows[0]["ApprovedDate"]); obj.TestedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["TestedBy"])); obj.TestedDate = Convert.ToDateTime(dt.Rows[0]["TestDate"]); obj.Status = (PRPDCAP.CAPStatus)Enum.Parse(typeof(PRPDCAP.CAPStatus), Convert.ToString(dt.Rows[0]["CAPStatus"])); obj.ReworkMTN = Convert.ToInt64(dt.Rows[0]["ReworkMTN"]); obj.DisposeMTN = Convert.ToInt64(dt.Rows[0]["DisposeMTN"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public PRPDBatchActivity Get(long PRPDBatchActivityID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDBatchActivity", PRPDBatchActivityID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatchActivityByID", paramList); PRPDBatchActivity obj = new PRPDBatchActivity(); if (dt.Rows.Count > 0) { obj.PRPDBatchActivityID = Convert.ToInt64(dt.Rows[0]["PRPDBatchActivity"]); obj.PRPDBatchID = Convert.ToString(dt.Rows[0]["PRPDBatchID"]); obj.MainActID = Convert.ToInt64(dt.Rows[0]["MainActID"]); obj.StartedDate = Convert.ToDateTime(dt.Rows[0]["StartedDate"]); if (dt.Rows[0]["EndDate"] != DBNull.Value) { obj.EndDate = Convert.ToDateTime(dt.Rows[0]["EndDate"]); } obj.SupervisedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["SupervisedBy"])); obj.Comments = Convert.ToString(dt.Rows[0]["Comments"]); obj.State = (PRPDBatchActivity.ActStatus)Enum.Parse(typeof(PRPDBatchActivity.ActStatus), Convert.ToString(dt.Rows[0]["ActStatus"])); obj.SectionOverHeadRate = Convert.ToDecimal(dt.Rows[0]["SectionOverHeadRate"]); obj.StartQty = Convert.ToDecimal(dt.Rows[0]["StartQty"]); if (dt.Rows[0]["StopQty"] != DBNull.Value) { obj.StopQty = Convert.ToDecimal(dt.Rows[0]["StopQty"]); } } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public RPDBatchCollec Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_RPDBatch"); RPDBatchCollec objCollec = new RPDBatchCollec(); RPDBatch obj = new RPDBatch(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { obj.RPDBatchID = Convert.ToString(dt.Rows[i]["RPDBatchID"]); obj.RPDBatchSupervisedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["RPDBatchSuperviserID"])); obj.RPDBatchMaterial = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["RPDBatchMaterialCode"])); obj.RPDBatchQty = Convert.ToDecimal(dt.Rows[i]["RPDBatchQty"]); obj.RPDBatchInstructedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["RPDBatchInstructedBy"])); obj.RPDBatchInstructedDate = Convert.ToDateTime(dt.Rows[i]["RPDBatchInstructedDate"]); obj.RPDBatchStartDate = Convert.ToDateTime(dt.Rows[i]["RPDBatchStartDate"]); obj.RPDBatchEndDate = Convert.ToDateTime(dt.Rows[i]["RPDBatchEndDate"]); obj.RPDBatchFinalQty = Convert.ToDecimal(dt.Rows[i]["RPDBatchFinalQty"]); obj.Status = (RPDBatch.RPDBatchStatus)Enum.Parse(typeof(RPDBatch.RPDBatchStatus), Convert.ToString(dt.Rows[i]["RPDBatchStatus"])); obj.RPDBatchMR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["RPDBatchMRNO"])); obj.Type = Convert.ToString(dt.Rows[i]["RPDBatchType"]); obj.ApprovedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["RPDBatchApprovedBy"])); obj.ApprovedDate = Convert.ToDateTime(dt.Rows[i]["RPDBatchApprovedDate"]); obj.EndBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["RPDBatchEndBy"])); objCollec.Add(obj); } } return(objCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
//public DepartmentCollec Get() //{ // tblDepartmentTableAdapter da = new tblDepartmentTableAdapter(); // da.Connection = Connection; // MRPDataSet1 dsMRP = new MRPDataSet1(); // Employee_DL objEmpDL = new Employee_DL(Connection); // DepartmentCollec objDepCollec = new DepartmentCollec(); // try // { // da.Fill(dsMRP.tblDepartment); // foreach (MRPDataSet1.tblDepartmentRow dr in dsMRP.tblDepartment) // { // Department objDep = new Department(); // objDep.DepDescription = dr.DepDescription; // objDep.DepHead = objEmpDL.Get(dr.ExecutiveID); // objDep.DepID = Convert.ToInt64(dr.DepID); // objDep.DepName = dr.DepName; // objDep.DepType = dr.Type; // objDep.DivisionID = Convert.ToInt64(dr.DivisionID); // objDepCollec.Add(objDep); // } // return objDepCollec; // } // catch (Exception ex) // { // throw new Exception(ex.Message, ex); // } // finally // { // da.Dispose(); // dsMRP.Dispose(); // objEmpDL = null; // } //} public Department Get(long DepID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DepID", DepID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_DepartmentByID", paramList); Department obj = new Department(); obj.DepDescription = Convert.ToString(dt.Rows[0]["DepDescription"]); obj.DepHead = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["ExecutiveID"])); obj.DepID = Convert.ToInt64(dt.Rows[0]["DepID"]); obj.DepName = Convert.ToString(dt.Rows[0]["DepName"]); obj.DepType = Convert.ToString(dt.Rows[0]["Type"]); obj.DivisionID = Convert.ToInt64(dt.Rows[0]["DivisionID"]); return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public User Login(String UserName, String Password) { User objUser = new User(); Employee_DL objEmpDL = new Employee_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@UserName", UserName), new SqlParameter("@Password", Password) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_User_Login", paramList); if (dt.Rows.Count > 0) { objUser.UserAnswer = Convert.ToString(dt.Rows[0]["Answer"]); objUser.UserEmp = objEmpDL.Get(Convert.ToString(dt.Rows[0]["EmpID"])); objUser.UserID = Convert.ToInt64(dt.Rows[0]["UserID"]); objUser.UserName = Convert.ToString(dt.Rows[0]["UserName"]); objUser.UserPassword = Convert.ToString(dt.Rows[0]["Password"]); objUser.UserQuestion = Convert.ToString(dt.Rows[0]["Question"]); objUser.UserStatus = Convert.ToBoolean(dt.Rows[0]["Status"]); objUser.UserRoleID = Convert.ToInt64(dt.Rows[0]["UserRoleID"]); if (dt.Rows[0]["LastLoggedIn"] != DBNull.Value) { objUser.LastLoggedIn = Convert.ToDateTime(dt.Rows[0]["LastLoggedIn"]); } if (dt.Rows[0]["Online"] != DBNull.Value) { objUser.Online = Convert.ToBoolean(dt.Rows[0]["Online"]); } if (dt.Rows[0]["ExpiryDate"] != DBNull.Value) { objUser.ExpiryDate = Convert.ToDateTime(dt.Rows[0]["ExpiryDate"]); } } return(objUser); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public CompanyOverHeadRate Get() { try { CompanyOverHeadRate obj = new CompanyOverHeadRate(); DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_OverheadRates"); obj.EnterdBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["EnterdBy"])); obj.EnterdDate = Convert.ToDateTime(dt.Rows[0]["Date"]); obj.ID = Convert.ToInt64(dt.Rows[0]["DepID"]); obj.Rate = Convert.ToDecimal(dt.Rows[0]["Rate"]); return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public STDBatch Get(string STDBatchID) { BasicProduct_DL objBasicProductDL = new BasicProduct_DL(Connection); FinishProduct_DL objFinishProductDL = new FinishProduct_DL(Connection); STDBatch objSTDBatch = new STDBatch(); Employee_DL objEmpDL = new Employee_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@STDBatchID", STDBatchID) }; STDBatch obj = new STDBatch(); DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_STDBatch_By_ID", paramList); if (dt.Rows.Count > 0) { if (dt.Rows[0]["STDBatchID"] != null) { obj.STDBatchID = Convert.ToString(dt.Rows[0]["STDBatchID"]); } if (dt.Rows[0]["STDBatchDescription"] != null) { obj.STDBatchDescription = Convert.ToString(dt.Rows[0]["STDBatchDescription"]); } if (dt.Rows[0]["STDBasicProductCode"] != null) { obj.STDBatchBasicProduct = objBasicProductDL.Get(Convert.ToString(dt.Rows[0]["STDBasicProductCode"])); } if (dt.Rows[0]["STDFinishProductCode"] != null) { obj.STDBatchFinishProduct = objFinishProductDL.Get(Convert.ToString(dt.Rows[0]["STDFinishProductCode"])); } obj.STDBatchSize = Convert.ToDecimal(dt.Rows[0]["STDBatchSize"]); obj.STDBatchInstructedBy = objEmpDL.Get(Convert.ToString(dt.Rows[0]["STDInstructedBy"])); obj.STDInstructedDate = Convert.ToDateTime(dt.Rows[0]["STDInstructedDate"]); obj.STDBatchType = Convert.ToString(dt.Rows[0]["STDBatchType"]); obj.STDDuration = Convert.ToDecimal(dt.Rows[0]["STDDuration"]); obj.EditableBatch = Convert.ToBoolean(dt.Rows[0]["EditableBatch"]); obj.LabourHours = Convert.ToDecimal(dt.Rows[0]["LabourHours"]); obj.MachineHours = Convert.ToDecimal(dt.Rows[0]["MachineHours"]); obj.InputQty = Convert.ToDecimal(dt.Rows[0]["InputQty"]); obj.OutputQty = Convert.ToDecimal(dt.Rows[0]["OutputQty"]); if (dt.Rows[0]["SpecificGravity"] != DBNull.Value) { obj.SpecificGravity = Convert.ToBoolean(dt.Rows[0]["SpecificGravity"]); } if (dt.Rows[0]["Water"] != DBNull.Value) { obj.Water = Convert.ToDecimal(dt.Rows[0]["Water"]); } } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Batch Get(String BatchID) { Batch objBatch = new Batch(); Employee_DL objEmplyeeDL = new Employee_DL(Connection); Batch_DL objBatchDL = new Batch_DL(Connection); STDBatch_DL objSTDBatchDL = new STDBatch_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchID", BatchID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_ID", paramList); if (dt.Rows.Count > 0) { if (dt.Rows[0]["BatchApprovedBy"].ToString() != "N/A") { objBatch.BatchApprovedBy = objEmplyeeDL.Get(Convert.ToString(dt.Rows[0]["BatchApprovedBy"])); } if (dt.Rows[0]["BatchApprovedDate"] != null) { objBatch.BatchApprovedDate = Convert.ToDateTime(dt.Rows[0]["BatchApprovedDate"]); } objBatch.BatchDivideCount = Convert.ToInt32(dt.Rows[0]["BatchDivideCount"]); if (dt.Rows[0]["BatchEndDate"] != null) { objBatch.BatchEndDate = Convert.ToDateTime(dt.Rows[0]["BatchEndDate"]); } if (dt.Rows[0]["BatchGeneratedBy"].ToString() != "N/A") { objBatch.BatchGenerateBy = objEmplyeeDL.Get(Convert.ToString(dt.Rows[0]["BatchGeneratedBy"])); } objBatch.BatchGenerateDate = Convert.ToDateTime(dt.Rows[0]["BatchGeneratedDate"]); objBatch.BatchID = Convert.ToString(dt.Rows[0]["BatchID"]); if (dt.Rows[0]["BatchStartDate"] != null) { objBatch.BatchStartDate = Convert.ToDateTime(dt.Rows[0]["BatchStartDate"]); } objBatch.BatchStatus = (Batch.Status)dt.Rows[0]["BatchStatus"]; if (dt.Rows[0]["BatchSuperviser"].ToString() != "N/A") { objBatch.BatchSuperviser = objEmplyeeDL.Get(Convert.ToString(dt.Rows[0]["BatchSuperviser"])); } objBatch.BatchType = Convert.ToString(dt.Rows[0]["BatchType"]); if (dt.Rows[0]["BatchFinalQty"] != DBNull.Value) { objBatch.BatchFinalQty = Convert.ToDecimal(dt.Rows[0]["BatchFinalQty"]); } objBatch.BatchSize = Convert.ToDecimal(dt.Rows[0]["BatchSize"]); if (dt.Rows[0]["FinalizedBy"].ToString() != "") { objBatch.FinalizedBy = objEmplyeeDL.Get(Convert.ToString(dt.Rows[0]["FinalizedBy"])); } if (dt.Rows[0]["FinalizedDate"] != DBNull.Value) { objBatch.FinalizedDate = Convert.ToDateTime(dt.Rows[0]["FinalizedDate"]); } objBatch.StandardBatch = objSTDBatchDL.Get(Convert.ToString(dt.Rows[0]["BatchSTDBatchID"])); } return(objBatch); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public PRPDBatchActivityDetails.PRPDBatchActivityDetailsCollc Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatchActivityDetails"); PRPDBatchCollec objCollec = new PRPDBatchCollec(); PRPDBatch obj = new PRPDBatch(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { obj.PRPDBatchID = Convert.ToString(dt.Rows[i]["PRPDBatchID"]); obj.PRPDBatchSuperviser = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchSuperviserID"])); obj.PRPDBatchMaterial = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchMaterialCode"])); obj.PRPDBatchQty = Convert.ToDecimal(dt.Rows[i]["PRPDBatchQty"]); obj.PRPDBatchInstructedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchInstructedBy"])); obj.PRPDBatchInstructedDate = Convert.ToDateTime(dt.Rows[i]["PRPDBatchInstructedDate"]); obj.PRPDBatchStartedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchStartedBy"])); obj.PRPDBatchStartDate = Convert.ToDateTime(dt.Rows[i]["PRPDBatchStartDate"]); obj.PRPDBatchApprovedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchApprovedBy"])); obj.PRPDBatchApprovedDate = Convert.ToDateTime(dt.Rows[i]["PRPDBatchApprovedDate"]); obj.PRPDBatchEndBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchEndBy"])); obj.PRPDBatchEndDate = Convert.ToDateTime(dt.Rows[i]["PRPDBatchEndDate"]); obj.Status = (PRPDBatch.PRPDBatchStatus)Enum.Parse(typeof(PRPDBatch.PRPDBatchStatus),Convert.ToString(dt.Rows[i]["PRPDBatchStatus"]); obj.PRPDBatchMTNIN = Convert.ToInt64(dt.Rows[i]["MTNIN"]); obj.PRPDBatchMTNOUT = objMTN_DL.Get(Convert.ToInt32(dt.Rows[i]["MTNOUT"])); obj.UnitCost = Convert.ToDecimal(dt.Rows[i]["UnitCost"]); obj.PRPDBatchInspectedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["InspectedBy"])); obj.PRPDBatchInspectedDate = Convert.ToDateTime(dt.Rows[i]["InspectedDate"]); obj.PRPDBatchHandOverBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["HandOverBy"])); obj.PRPDBatchHandOverDate = Convert.ToDateTime(dt.Rows[i]["HandOverDate"]); obj.PRPDBatchFinalQty = Convert.ToDecimal(dt.Rows[i]["FinalQty"]); obj.PRPDSampleSize = Convert.ToString(dt.Rows[i]["SampleSize"]); obj.PRPDBatchComments = Convert.ToString(dt.Rows[i]["Comments"]); obj.Type = (PRPDBatch.PRPDType) Convert.ToInt64(dt.Rows[i]["BatchType"]); obj.PRPDBatchTotalImpurities = Convert.ToDecimal(dt.Rows[i]["TotalImpurities"]); obj.PRPDCAPID = Convert.ToDecimal(dt.Rows[i]["PRPDCAPID"]); obj.MRIN = Convert.ToInt64(dt.Rows[i]["MRIN"]); obj.PRPDBatchMaterialName = Convert.ToString(dt.Rows[i]["MaterialDescription"]); obj.OutSourceQty = Convert.ToDecimal(dt.Rows[i]["OutSourceQty"]); objCollec.Add(obj); } } return objCollec; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }