public void LoadForm(String EmpRole)
{
objSectionDL = new Section_DL(ConnectionStringClass.GetConnection());
objEmployeeDL = new Employee_DL(ConnectionStringClass.GetConnection());
cmbSection.DataSource = objSectionDL.GetDataView();
EmployeeRole = EmpRole;
}
private void gvMRList_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
bindItemList.DataSource = null;
long MRNO = Convert.ToInt64(gvMRList.Rows[e.RowIndex].Cells["MRNO"].Value);
MR objMRTemp = objMRDL.Get(MRNO);
objMR = new MR();
objMR = objMRTemp;
Load_MRItem();
txtDepartment.Text = objMR.MRDepartmentFrom.DepName;
ItemSelect = true;
Section_DL objSectionDL = new Section_DL(ConnectionStringClass.GetConnection());
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmCosting_Load(object sender, EventArgs e)
{
StockHoldingRate_DL objStockHoldingRateDL = new StockHoldingRate_DL(ConnectionStringClass.GetConnection());
Employee_DL objEmpDL = new Employee_DL(ConnectionStringClass.GetConnection());
Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection());
Section_DL objSection_DL = new Section_DL(ConnectionStringClass.GetConnection());
try
{
StockHoldingRate obj = new StockHoldingRate();
obj = objStockHoldingRateDL.GetFinal();
Employee objChangedBy = objEmpDL.Get(obj.ChangedBy);
txtEnterdBy.Text = objChangedBy.EmployeeName;
txtEnterdDate.Text = obj.FromDate.Value.ToShortDateString();
txtCurrentRate.Text = obj.Cost.ToString();
bindStockHolding.DataSource = objStockHoldingRateDL.Get();
bindDepartment.DataSource = objSection_DL.GetDataView();
objCompanyOverHeadRate = objCompanyOverHeadRate_DL.Get();
if (objCompanyOverHeadRate != null)
{
txtComDate.Text = objCompanyOverHeadRate.EnterdDate.ToShortDateString();
txtComEnterd.Text = objCompanyOverHeadRate.EnterdBy.EmployeeNameID;
txtComRate.Text = objCompanyOverHeadRate.Rate.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadForm(String EmpRole, String DivisionType)
{
objSectionDL = new Section_DL(ConnectionStringClass.GetConnection());
objEmployeeDL = new Employee_DL(ConnectionStringClass.GetConnection());
// cmbSection.DataSource = objSectionDL.Get);
cmbSection.DataSource = objSectionDL.GetData(DivisionType);
EmployeeRole = EmpRole;
}
public void Initialize(SqlConnection Conn)
{
objDepDL = new Department_DL(Conn);
objEmpRoleDL = new EmployeeRole_DL(Conn);
objEmpDL = new Employee_DL(Conn);
objSectionDL = new Section_DL(Conn);
ucSectionFilter1.Load(Conn);
}
private void Load_Sections()
{
Section_DL objSection_DL = new Section_DL(ConnectionStringClass.GetConnection());
try
{
objSourceSections.DataSource = objSection_DL.GetDataView();
cmbSections.DataSource = objSourceSections;
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while loading Section", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void cmbDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmbDepartment.SelectedValue != null)
{
Section_DL objSectionDL = new Section_DL(ConnectionStringClass.GetConnection());
cmbSection.DataSource = objSectionDL.GetDataView(Convert.ToInt64(cmbDepartment.SelectedValue));
}
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while loading Sections", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnSaveDep_Click(object sender, EventArgs e)
{
try
{
Section_DL objSection_DL = new Section_DL(ConnectionStringClass.GetConnection());
Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection());
OverheadRates objOverheadRates = new OverheadRates();
OverheadRates_DL objOverheadRates_DL = new OverheadRates_DL(ConnectionStringClass.GetConnection());
Employee_DL objEmpDL = new Employee_DL(ConnectionStringClass.GetConnection());
if (objSelectedSections.DepID != 0)
{
Sections objSections = objSelectedSections;
if (textBox1.Text != "")
{
if (objSections.DepID != 0)
{
objOverheadRates.SectionID = objSections.SectionID;
objOverheadRates.EnterdBy = CurrentUser.EmployeeID;
objOverheadRates.EnterdDate = DateTime.Now;
objOverheadRates.Rate = Convert.ToDecimal(textBox1.Text);
objOverheadRates_DL.Add(objOverheadRates);
ClearDep();
bindDepartment.DataSource = objSection_DL.GetDataView();
}
}
else
{
MessageBox.Show(this, "Please enter a valid Overhead Rate", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show(this, "Please Select a Department from the list", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while saving overhead rate", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void Load(SqlConnection conn)
{
try
{
objSectionDL = new Section_DL(conn);
objEmpDL = new Employee_DL(conn);
objDepDL = new Department_DL(conn);
objDivisionDL = new Division_DL(conn);
bindDivisions.DataSource = objDivisionDL.GetDataView();
cmbDivision.DataSource = bindDivisions;
cmbSupervisor.DataSource = objEmpDL.Get_By_RoleType("Staff", true);
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while loading", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void gvDepartment_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection());
Section_DL objSection_DL = new Section_DL(ConnectionStringClass.GetConnection());
OverheadRates objOverheadRates = new OverheadRates();
OverheadRates_DL objOverheadRates_DL = new OverheadRates_DL(ConnectionStringClass.GetConnection());
Employee_DL objEmpDL = new Employee_DL(ConnectionStringClass.GetConnection());
ClearDep();
if (true)
{
Sections objSection = objSection_DL.Get(Convert.ToInt64(gvDepartment.Rows[e.RowIndex].Cells["colDepID"].Value));
Department objDep = objDepDL.Get(objSection.DepID);
if (objDep.DepID != 0)
{
txtSection.Text = objSection.SectionName;
objSelectedSections = objSection;
txtDID.Text = objDep.DepID.ToString();
txtDepartmentName.Text = objDep.DepName;
objOverheadRates = objOverheadRates_DL.Get(objSection.SectionID);
if (objOverheadRates.SectionID != 0)
{
txtDepCurrent.Text = objOverheadRates.Rate.ToString();
Employee objEmp = objEmpDL.Get(objOverheadRates.EnterdBy);
txtDepEnterdBy.Text = objEmp.EmployeeName;
txtDepEnterdDate.Text = objOverheadRates.EnterdDate.ToShortDateString();
}
}
}
}
catch (Exception)
{
MessageBox.Show(this, "Error occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
