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