private void Apply_Leave_Insert_Update() { try { DateTime D1 = DateTime.ParseExact(txtToDate.Text, "yyyy-MM-dd", null); DateTime D2 = DateTime.ParseExact(txtFromDate.Text, "yyyy-MM-dd", null); TimeSpan ts = D1 - D2; TimeSpan time1 = TimeSpan.FromDays(1); ts = ts.Add(time1); ApplyLeaveEntity _objEntity = new ApplyLeaveEntity { leave_id = Convert.ToInt32(hf_id.Value.ToString()), emp_id = Convert.ToInt32(hf_Emp_id.Value.ToString()), //emp_id = Emp_id, to_date = txtToDate.Text.Trim(), from_date = txtFromDate.Text.Trim(), calender_year = txtCalYear.Text.Trim(), no_of_days = ts.Days.ToString(), leave_type = dropleaveType.SelectedValue.Trim(), reason = txtReason.Text.Trim(), CreatedBy = hf_Emp_id.Value.ToString() }; int IsSuccess = objDal.Apply_Leave_Insert_Update(_objEntity); if (IsSuccess > 0) { lblMsg.Text = CommanClass.ShowMessage("success", "Success", "Leave applyed successfully !!"); SendMail(txtReason.Text, txtFromDate.Text, txtToDate.Text); Clear_text(); } else { lblMsg.Text = CommanClass.ShowMessage("info", "Info", "Leave was applyed please try again!!"); } Bing_Leaves(Convert.ToInt32(hf_Emp_id.Value.ToString())); } catch (Exception ex) { lblMsg.Text = CommanClass.ShowMessage("danger", "Error", ex.Message); } }
public int Apply_Leave_Insert_Update(ApplyLeaveEntity ObjApplyLeave) { Hashtable hst = new Hashtable() { { "in_leave_id", ObjApplyLeave.leave_id }, { "in_empid", ObjApplyLeave.emp_id }, { "in_from_date", ObjApplyLeave.from_date }, { "in_to_date", ObjApplyLeave.to_date }, { "in_reason", ObjApplyLeave.reason }, { "in_no_of_days", ObjApplyLeave.no_of_days }, { "in_leave_type", ObjApplyLeave.leave_type }, { "in_calender_year", ObjApplyLeave.calender_year }, { "in_CreatedBy", ObjApplyLeave.CreatedBy }, }; int i = ExecuteNonQuery("leave_details_insert_update", hst); return(i); }