public void UpdateRecord(Objects.Employees obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_EmployeesUpdate";
cmd.Parameters.AddWithValue("@EmployeeID", obj.EmployeeID);
cmd.Parameters.AddWithValue("@EmployeeName", obj.EmployeeName);
cmd.Parameters.AddWithValue("@FatherName", obj.FatherName);
cmd.Parameters.AddWithValue("@JoiningDate", obj.JoiningDate);
cmd.Parameters.AddWithValue("@CNIC", obj.CNIC);
cmd.Parameters.AddWithValue("@ContactNo", obj.ContactNo);
cmd.Parameters.AddWithValue("@Address", obj.Address);
cmd.Parameters.AddWithValue("@IsSalesman", obj.IsSalesman);
cmd.Parameters.AddWithValue("@BasicSalary", obj.BasicSalary);
cmd.Parameters.AddWithValue("@UserID", obj.UserID);
cmd.Parameters.AddWithValue("@DepartmentID", obj.DepartmentID);
cmd.Parameters.AddWithValue("@DesignationID", obj.DesignationID);
cmd.Parameters.AddWithValue("@ShiftID", obj.ShiftID);
cmd.Parameters.AddWithValue("@InActive", obj.InActive);
cmd.Parameters.AddWithValue("@AccountNo", obj.AccountNo);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text.Trim() == string.Empty)
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Enter Name.");
txtName.Focus();
return;
}
int vDeptID, vDesgID, vShiftID;
if (cboDepartment.SelectedIndex != -1)
{
int.TryParse(cboDepartment.SelectedValue.ToString(), out vDeptID);
}
else
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Select Department.");
cboDepartment.Focus();
return;
}
if (cboDesignation.SelectedIndex != -1)
{
int.TryParse(cboDesignation.SelectedValue.ToString(), out vDesgID);
}
else
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Select Designation.");
cboDesignation.Focus();
return;
}
if (cboShift.SelectedIndex != -1)
{
int.TryParse(cboShift.SelectedValue.ToString(), out vShiftID);
}
else
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Select Shift.");
cboShift.Focus();
return;
}
decimal vBasicSalary = 0;
decimal.TryParse(txtBasicSalary.Text, out vBasicSalary);
Objects.Employees obj = new Objects.Employees();
obj.EmployeeID = Int32.Parse(txtID.Text);
obj.EmployeeName = txtName.Text.Trim();
obj.FatherName = txtFatherName.Text.Trim();
obj.CNIC = txtCNIC.Text.Trim();
obj.ContactNo = txtContactNo.Text.Trim();
obj.DepartmentID = vDeptID;
obj.DesignationID = vDesgID;
obj.ShiftID = vShiftID;
obj.JoiningDate = dtJoiningDate.Value;
obj.BasicSalary = vBasicSalary;
obj.Address = txtAddress.Text.Trim();
obj.AccountNo = txtID.Tag.ToString();
obj.InActive = chkInActive.Checked;
obj.IsSalesman = chkSalesman.Checked;
obj.UserID = vUserID;
//Insert Account
var AccDAL = new DAL.AccountChart();
AccDAL.connectionstring = objDAL.connectionstring;
Objects.AccountChart objAcc = new Objects.AccountChart();
objAcc.AccountNo = obj.AccountNo;
objAcc.AccountTitle = obj.EmployeeName;
objAcc.AccountType = "LIABILITY";
objAcc.AccountSubType = "Employee";
objAcc.IsParty = false;
objAcc.IsBank = false;
objAcc.OpeningDebit = 0;
objAcc.OpeningCredit = 0;
if (!vOpenMode)
{
objAcc.AccountNo = AccDAL.getNextNo("LIABILITY").ToString();
AccDAL.InsertRecord(objAcc);
//Insert Party
obj.EmployeeID = objDAL.getNextNo();
obj.AccountNo = objAcc.AccountNo;
objDAL.InsertRecord(obj);
}
else
{
if (!string.IsNullOrEmpty(objAcc.AccountNo))
{
// UPdate Account
AccDAL.UpdateRecord(objAcc);
}
else
{
objAcc.AccountNo = AccDAL.getNextNo("LIABILITY").ToString();
AccDAL.InsertRecord(objAcc);
obj.AccountNo = objAcc.AccountNo;
}
objDAL.UpdateRecord(obj);
}
Message.ShowMessage(MyMessages.MessageType.SaveRecord);
LoadGrid();
btnClear_Click(sender, e);
}
catch (Exception exc)
{
Message.ShowMessage(MyMessages.MessageType.Error, exc.Message);
}
}