public void InsertRecordBody(Objects.SalaryBody obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_SalaryBodyInsert"; cmd.Parameters.AddWithValue("@SalaryID", obj.SalaryID); cmd.Parameters.AddWithValue("@EmployeeID", obj.EmployeeID); cmd.Parameters.AddWithValue("@Presents", obj.Presents); cmd.Parameters.AddWithValue("@Leaves", obj.Leaves); cmd.Parameters.AddWithValue("@BasicSalary", obj.BasicSalary); cmd.Parameters.AddWithValue("@Allowances", obj.Allowances); cmd.Parameters.AddWithValue("@Bonus", obj.Bonus); cmd.Parameters.AddWithValue("@Deduction", obj.Deduction); cmd.Parameters.AddWithValue("@NetSalary", obj.NetSalary); 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); } }