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);
}
}
