public frmAddPRPDActivity(User objuser, PRPDBatch objPRPDBatch, PRPDBatchActivity objPRPDBatchAct)
{
this.objPRPDBatch = objPRPDBatch;
CurrentUser = objuser;
objPRPDBatchActivity = objPRPDBatchAct;
InitializeComponent();
txtComment.Text = objPRPDBatchActivity.Comments;
//cmbSupervisedBy.SelectedValue = objPRPDBatchActivity.SupervisedBy;
}
private void ClearActivityTab()
{
txtStatus.Text = "";
txtMainActivity.Text = "";
txtID.Text = "";
objPRPDBatchActivity = null;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
btnDetails.Enabled = false;
grpActivityDetails.Enabled = false;
}
private void gvActivity_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
objPRPDBatchActivity = objPRPDBatchActivity_DL.Get(Convert.ToInt64(gvActivity.Rows[e.RowIndex].Cells["PRPDBatchActID"].Value));
if (objPRPDBatchActivity != null)
{
txtID.Text = objPRPDBatchActivity.PRPDBatchActivityID.ToString();
MainActivity objmainAct = objMainActivity_DL.Get(objPRPDBatchActivity.MainActID);
txtMainActivity.Text = objmainAct.MainActivityTitle;
txtStatus.Text = objPRPDBatchActivity.State.ToString();
//if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Started)
//{
//}
//else
//{
// MessageBox.Show(this, "Activity not started", "Activity Status", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//}
if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Initial)
{
btnEdit.Enabled = true;
btnDelete.Enabled = true;
grpActivityDetails.Enabled = true;
MessageBox.Show(this, "Activity not started", "Activity Status", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Started)
{
frmPRPDBatchActivity obj = new frmPRPDBatchActivity(_CurrentUser, objPRPDBatchActivity.PRPDBatchActivityID);
obj.ShowDialog();
obj.StartPosition = FormStartPosition.CenterScreen;
}
else if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Finished)
{
grpActivityDetails.Enabled = false;
btnDetails.Enabled = false;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
//MessageBox.Show(this, "Activity Finished", "Activity Status", MessageBoxButtons.OK, MessageBoxIcon.Warning);
frmPRPDBatchActivity obj = new frmPRPDBatchActivity(_CurrentUser, objPRPDBatchActivity.PRPDBatchActivityID);
obj.ShowDialog();
obj.StartPosition = FormStartPosition.CenterScreen;
}
}
}
catch (Exception)
{
MessageBox.Show(this, "Error loading activity", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void frmBatchList_Load(object sender, EventArgs e)
{
objPRPDBatchActivity = objPRPDBatchActivity_DL.Get(PRPDBatchActivityID);
objActivity = objMainActivity_DL.Get(objPRPDBatchActivity.MainActID);
txtActivity.Text = objActivity.MainActivityTitle;
Load_Machine();
Load_employee();
Load_Labour_List();
Load_Machine_List();
rdbPermanentSection.Checked = true;
}
private void gvActivity_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
objPRPDBatchActivity = objPRPDBatchActivity_DL.Get(Convert.ToInt64(gvActivity.CurrentRow.Cells["PRPDBatchActivity"].Value));
if (objPRPDBatchActivity != null)
{
frmPRPDBatchActivity_View obj = new frmPRPDBatchActivity_View(_CurrentUser, objPRPDBatchActivity.PRPDBatchActivityID);
obj.ShowDialog();
obj.StartPosition = FormStartPosition.CenterScreen;
}
}
catch (Exception)
{
MessageBox.Show(this, "Error loading activity", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public int Update(PRPDBatchActivity obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@EndDate", obj.EndDate),
new SqlParameter("@StopQty", obj.StopQty),
new SqlParameter("@ActStatus", obj.State),
new SqlParameter("@PRPDBatchActivity", obj.PRPDBatchActivityID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_PRPDBatchActivity", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update_Initial(PRPDBatchActivity obj, long Original_PRPDBatchActivity)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@EndDate", obj.EndDate),
new SqlParameter("@Comments", obj.Comments),
new SqlParameter("@ActStatus", obj.State),
new SqlParameter("@PRPDBatchActivity", obj.PRPDBatchActivityID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_PRPDBatchActivity_Initial", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public PRPDBatchActivity Get(string PRPDBatchID, long MainActID, PRPDBatchActivity.ActStatus ActState)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ActStatus", ActState),
new SqlParameter("@MainActID", MainActID),
new SqlParameter("@PRPDBatchID", PRPDBatchID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatchActivityByStatus", 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 int Add(PRPDBatchActivity obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchID", obj.PRPDBatchID),
new SqlParameter("@MainActID", obj.MainActID),
new SqlParameter("@ActStatus", obj.State),
new SqlParameter("@StartedDate", obj.StartedDate),
new SqlParameter("@PRPDBatchActivityID", obj.PRPDBatchActivityID),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@StopQty", obj.StopQty)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDBatchActivity", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void frmBatchList_Load(object sender, EventArgs e)
{
objPRPDBatchActivity = objPRPDBatchActivity_DL.Get(PRPDBatchActivityID);
objActivity = objMainActivity_DL.Get(objPRPDBatchActivity.MainActID);
txtActivity.Text = objActivity.MainActivityTitle;
Load_Machine();
Load_employee();
Load_Labour_List();
Load_Machine_List();
rdbPermanentSection.Checked = true;
if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Finished)
{
cmbSections.Enabled = false;
btnMultiple.Enabled = false;
rdbPermanentAll.Enabled = false;
rdbOutsource.Enabled = false;
rdbPermanentSection.Enabled = false;
txtNos.Enabled = false;
label6.Enabled = false;
txtNos.Enabled = false;
cmbMachine.Enabled = false;
label4.Enabled = false;
txtMachineStart.Enabled = false;
label5.Enabled = false;
txtMachineStop.Enabled = false;
label1.Enabled = false;
txtFrom.Enabled = false;
label2.Enabled = false;
txtTo.Enabled = false;
label3.Enabled = false;
txtOT.Enabled = false;
label7.Enabled = false;
txtOTMinutes.Enabled = false;
cmbEmployee.Enabled = false;
}
}
public long Add_Initial(PRPDBatchActivity obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchID", obj.PRPDBatchID),
new SqlParameter("@MainActID", obj.MainActID),
new SqlParameter("@ActStatus", obj.State),
new SqlParameter("@Comments", obj.Comments),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@SupervisedBy", obj.SupervisedBy.EmployeeID),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDBatchActivity_Initial", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public frmPRPDActDetails(User objUser, PRPDBatchActivity objPRPDBatchAct)
{
objPRPDBatchActivity = objPRPDBatchAct;
CurrentUser = objUser;
InitializeComponent();
}
public frmViewActivityDetails(User objUser, PRPDBatchActivity objPRPDBatchActivity)
{
this.objPRPDBatchActivity = objPRPDBatchActivity;
CurrentUser = objUser;
InitializeComponent();
}
private void gvActivity_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
objPRPDBatchActivity = objPRPDBatchActivity_DL.Get(Convert.ToInt64(gvActivity.CurrentRow.Cells["PRPDBatchActID"].Value));
if (objPRPDBatchActivity.PRPDBatchActivityID != 0)
{
txtID.Text = objPRPDBatchActivity.PRPDBatchActivityID.ToString();
MainActivity objmainAct = objMainActivity_DL.Get(objPRPDBatchActivity.MainActID);
txtMainActivity.Text = objmainAct.MainActivityTitle;
txtStatus.Text = objPRPDBatchActivity.State.ToString();
dtStartActivity.Value = objPRPDBatchActivity.StartedDate;
txtStartQty.Text = objPRPDBatchActivity.StartQty.ToString();
if (objPRPDBatchActivity.StopQty != 0)
{
txtStopQty.Text = objPRPDBatchActivity.StopQty.ToString();
}
else
{
txtStopQty.Text = "0";
}
//if (objPRPDBatchActivity.EndDate != null)
//{
// dtStopActivity.Value = objPRPDBatchActivity.EndDate;
//}
if (gvActivity.CurrentCell.OwningColumn.Name.Equals("ColAddDetails"))
{
if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Started)
{
//PRPD.PRPDBatchActivityForms.frmPRPDActDetails objFrm = new MRP_GUI.PRPD.PRPDBatchActivityForms.frmPRPDActDetails(CurrentUser, objPRPDBatchActivity);
//objFrm.ShowDialog(this);
grpActivityDetails.Enabled = true;
}
else if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Initial)
{
MessageBox.Show(this, "Activity not started", "Activity Status", MessageBoxButtons.OK, MessageBoxIcon.Warning);
grpActivityDetails.Enabled = true;
}
else if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Finished)
{
grpActivityDetails.Enabled = false;
MessageBox.Show(this, "Activity Finished", "Activity Status", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Initial)
{
btnEdit.Enabled = true;
btnDelete.Enabled = true;
grpActivityDetails.Enabled = true;
}
else if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Started)
{
btnDetails.Enabled = true;
grpActivityDetails.Enabled = true;
}
else if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Finished)
{
grpActivityDetails.Enabled = false;
btnDetails.Enabled = false;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
}
}
}
catch (Exception)
{
MessageBox.Show(this, "Error loading activity", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public frmMultipleLabour_PRPD(PRPDBatchActivity obj, int _SectionID)
{
InitializeComponent();
objPRPDBatchActivity = obj;
SectionID = _SectionID;
}
