public System.Data.DataTable GetDataView(long To, long From, 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("@MTNToDepID", To), new SqlParameter("@MTNFromDepID", From), new SqlParameter("@MTNStatus", Status) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_Dataview_By_ToDep_FromDep", paramList); return(dt); } 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 System.Data.DataTable GetDataView(long MTNNO) { 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("@MTNNO", MTNNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_Items", paramList); return(dt); } 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 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 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 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 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 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 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 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 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 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 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); } }