public DataTable InsertRecord(Objects.Salary obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_SalaryInsert";
cmd.Parameters.AddWithValue("@GenerateDate", obj.GenerateDate);
cmd.Parameters.AddWithValue("@SalaryMonth", obj.SalaryMonth);
cmd.Parameters.AddWithValue("@DepartmentID", obj.DepartmentID);
if (obj.DesignationID > 0)
{
cmd.Parameters.AddWithValue("@DesignationID", obj.DesignationID);
}
if (obj.ShiftID > 0)
{
cmd.Parameters.AddWithValue("@ShiftID", obj.ShiftID);
}
cmd.Parameters.AddWithValue("@Remarks", obj.Remarks);
cmd.Parameters.AddWithValue("@TotalSalary", obj.TotalSalary);
cmd.Parameters.AddWithValue("@UserID", obj.UserID);
return(new Database(connectionstring).ExecuteForDataTable(cmd));
}
catch (Exception exc)
{
throw exc;
}
}
public void UpdateRecord(Objects.Salary obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_SalaryUpdate";
cmd.Parameters.AddWithValue("@SalaryID", obj.SalaryID);
cmd.Parameters.AddWithValue("@GenerateDate", obj.GenerateDate);
cmd.Parameters.AddWithValue("@SalaryMonth", obj.SalaryMonth);
cmd.Parameters.AddWithValue("@DepartmentID", obj.DepartmentID);
cmd.Parameters.AddWithValue("@DesignationID", obj.DesignationID);
cmd.Parameters.AddWithValue("@ShiftID", obj.ShiftID);
cmd.Parameters.AddWithValue("@Remarks", obj.Remarks);
cmd.Parameters.AddWithValue("@TotalSalary", obj.TotalSalary);
cmd.Parameters.AddWithValue("@UserID", obj.UserID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (GridBody.Rows.Count == 0)
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Generate Salary First.");
btnGenerate.Focus();
return;
}
decimal vTotalSalary;
decimal.TryParse(txtTotalSalary.Text, out vTotalSalary);
int vDept, vDesig, vShift;
int.TryParse(cboDepartment.SelectedValue.ToString(), out vDept);
int.TryParse(cboDesignation.SelectedValue.ToString(), out vDesig);
int.TryParse(cboShift.SelectedValue.ToString(), out vShift);
Objects.Salary obj = new Objects.Salary();
obj.SalaryID = Int64.Parse(txtID.Text);
obj.GenerateDate = dtGenerate.Value;
obj.SalaryMonth = dtSalaryMonth.Value;
obj.DepartmentID = vDept;
if (vDesig > 0)
{
obj.DesignationID = vDesig;
}
if (vShift > 0)
{
obj.ShiftID = vShift;
}
obj.TotalSalary = vTotalSalary;
obj.Remarks = txtRemarks.Text.Trim();
obj.UserID = vUserID;
if (!vOpenMode)
{
//Insert
DataTable dt = objDAL.InsertRecord(obj);
obj.SalaryID = Int64.Parse(dt.Rows[0]["SalaryID"].ToString());
}
else
{
// UPdate
objDAL.DeleteRecordBody(obj.SalaryID);
objDAL.UpdateRecord(obj);
}
//Save Detail
foreach (DataGridViewRow dr in GridBody.Rows)
{
if (dr.Cells[0].Value != null)
{
Objects.SalaryBody objBody = new Objects.SalaryBody();
objBody.SalaryID = obj.SalaryID;
objBody.EmployeeID = Int64.Parse(dr.Cells["EmployeeID"].Value.ToString());
objBody.Presents = decimal.Parse(dr.Cells["Presents"].Value.ToString());
objBody.Leaves = decimal.Parse(dr.Cells["Leaves"].Value.ToString());
decimal vBasic, vAll, vBonus, vDeduct, vNet;
decimal.TryParse(dr.Cells["BasicSalary"].Value.ToString(), out vBasic);
decimal.TryParse(dr.Cells["Allowances"].Value.ToString(), out vAll);
decimal.TryParse(dr.Cells["Bonus"].Value.ToString(), out vBonus);
decimal.TryParse(dr.Cells["Deduction"].Value.ToString(), out vDeduct);
decimal.TryParse(dr.Cells["NetSalary"].Value.ToString(), out vNet);
objBody.BasicSalary = vBasic;
objBody.Allowances = vAll;
objBody.Bonus = vBonus;
objBody.Deduction = vDeduct;
objBody.NetSalary = vNet;
objDAL.InsertRecordBody(objBody);
}
}
Message.ShowMessage(MyMessages.MessageType.SaveRecord);
LoadGrid();
btnClear_Click(sender, e);
}
catch (Exception exc)
{
Message.ShowMessage(MyMessages.MessageType.Error, exc.Message);
}
}
