public int EmployeeLeave_Insert(EmployeeLeaveForInsertodel lv) { try { using (var con = GetDbConnection()) { var retValue = con.ExecuteScalar <int>("dbo.Usp_EmployeeLeave_Insert", new { @iIntEmployeeId = lv.EmployeeId, @iStrLeaveType = lv.LeaveType, @iBitIsWithPay = lv.IsWithPay, @iStrLeaveRemarks = lv.LeaveRemarks, @iDtLeaveDateFrom = lv.LeaveDateFrom, @iDtLeaveDateTo = lv.LeaveDateTo, @iStrCreatedBy = lv.CreatedBy }, commandType: CommandType.StoredProcedure); return(retValue); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public int EmployeeLeave_Insert(EmployeeLeaveForInsertodel lv) { return(_repo.EmployeeLeave_Insert(lv)); }
public void EmployeeLeave_Update(EmployeeLeaveForInsertodel lv) { _repo.EmployeeLeave_Update(lv); }
private void bttnSave_Click(object sender, EventArgs e) { try { if ((int)cmbEmployeeName.SelectedValue == 0) { ShowMessage.CustomErrorMessage("Select employee first."); cmbEmployeeName.Focus(); } else if (lblNoDays.Text == "") { ShowMessage.CustomErrorMessage("Input inclusive dates."); dtFrom.Focus(); } else if (int.Parse(lblNoDays.Text) <= 0) { ShowMessage.CustomErrorMessage("Invalid no. of days value."); dtFrom.Focus(); } else { var lv = new EmployeeLeaveForInsertodel { EmployeeId = (int)cmbEmployeeName.SelectedValue, IsWithPay = IsWithPay, LeaveType = LeaveType, LeaveDateFrom = dtFrom.Value, LeaveDateTo = dtTo.Value, LeaveRemarks = txtRemarks.Text, CreatedBy = GlobalSession.UserFullName }; if (ADD_STATE) { var result = svc.EmployeeLeave_Insert(lv); if (result > 0) { ShowMessage.ShowMessageBox(1); } else if (result == -1) { ShowMessage.ShowMessageBox(4); } else { ShowMessage.ShowMessageBox(3); } } else { lv.Id = leaveId; svc.EmployeeLeave_Update(lv); ShowMessage.ShowMessageBox(2); } bttnRefresh.PerformClick(); } } catch { ShowMessage.ShowMessageBox(3); } }