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