protected void btnLeaveSubmit_Click(object sender, EventArgs e)
        {
            LeaveData leaveData = new LeaveData();

            leaveData.LeaveType     = Convert.ToInt32(ddlLeaveType.SelectedValue.ToString());
            leaveData.LeaveTypeDesc = Enums.GetDescription((Enums.LeaveTypes)leaveData.LeaveType);
            Enums.LeaveDateTypes leaveDateTypes = (Enums.LeaveDateTypes)Enum.Parse(typeof(Enums.LeaveDateTypes), Request.Form["LeaveDateType"].ToString());
            leaveData.LeaveDateType = Enums.GetDescription(leaveDateTypes);
            leaveData.LeaveDates    = Request.Form["LeaveDates"].ToString().TrimEnd(',');
            leaveData.LeaveRemarks  = Request.Form["leaveRemarks"].ToString();
            leaveData.LeaveUser     = UserInitiate.LoggedUser;
            DataSet resultSet = lvDb.InsertLeave(leaveData);
            string  status    = resultSet.Tables[0].Rows[0][0].ToString();
            string  statusMsg = resultSet.Tables[0].Rows[0][1].ToString();

            if (status == "0")
            {
                Response.Redirect(Request.RawUrl);
            }
            else
            {
                Response.Redirect(string.Format("~/AppStatus.aspx?status={0}", statusMsg));
            }
        }