Exemple #1
0
        //To CheckDuplicateLeave
        #region [Check Duplicate Leave]

        public int CheckDuplicateLeave_DL(EWA_LeaveType objEWA)
        {
            try
            {
                prmList    = new string[6];
                prmList[0] = "@Action";
                prmList[1] = "CheckData";
                prmList[2] = "@LeaveName";
                prmList[3] = objEWA.LeaveName;
                prmList[4] = "@OrgId";
                prmList[5] = objEWA.OrgId;

                DataSet dsData = ObjHelper.FillControl(prmList, "SP_Leave");
                if (dsData.Tables[0].Rows.Count > 0)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
Exemple #2
0
        //To CheckDuplicateDataOfLeave
        #region [Check Duplicate Leave]

        public int CheckDuplicateLeave_BL(EWA_LeaveType objEWA)
        {
            try
            {
                int i = objDL.CheckDuplicateLeave_DL(objEWA);
                return(i);
            }
            catch (Exception)
            {
                throw;
            }
        }
 //Leave Type for All Grid Bind
 #region [Leave Type for All Grid Bind]
 private void GrdLeaveTypeForAllBind()
 {
     try
     {
         BL_LeaveType  objBL  = new BL_LeaveType();
         EWA_LeaveType objEWA = new EWA_LeaveType();
         objEWA.OrgId = "1";        //Session["OrgId"].toString();
         DataSet ds = objBL.LeaveTypeGridBind_BL(objEWA);
         GrdLeaveTypeForAll.DataSource = ds;
         GrdLeaveTypeForAll.DataBind();
     }
     catch (Exception exp)
     {
         throw exp;
     }
 }
Exemple #4
0
        //Insert Update Delete operaeion on Leave Table
        #region [ActionPerformed For Leave]

        public int LeaveAction_BL(EWA_LeaveType objEWA)
        {
            try
            {
                int flag = objDL.LeaveAction_DL(objEWA);
                return(flag);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objDL = null;
            }
        }
Exemple #5
0
        //To Call LeaveGridBind
        #region [Leave Grid Bind]

        public DataSet LeaveTypeGridBind_BL(EWA_LeaveType objEWA)
        {
            try
            {
                DL_LeaveType objDL = new DL_LeaveType();
                DataSet      ds    = objDL.BindLeaveTypeGrid_DL(objEWA);
                return(ds);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                objDL = null;
            }
        }
Exemple #6
0
        //To Bind LeaveGrid
        #region [Bind Leave Grid]

        public DataSet BindLeaveTypeGrid_DL(EWA_LeaveType objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[6];
                prmList[0] = "@Action";
                prmList[1] = "SelectData";
                prmList[2] = "@OrgId";
                prmList[3] = "1";
                prmList[4] = "@UserId";
                prmList[5] = "1";

                ds = ObjHelper.FillControl(prmList, "SP_Leave");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                else
                {
                    DataTable dt = new DataTable();
                    dt.Columns.Add("LeaveId");
                    dt.Columns.Add("LeaveName");
                    dt.Columns.Add("LeaveCode");
                    dt.Columns.Add("LeaveCount");

                    dt.Rows.Add();
                    dt.Rows.Add();
                    dt.Rows.Add();
                    dt.Rows.Add();

                    return(null);
                }
            }
            catch (Exception)
            {
                // GeneralErr(exp.Message.ToString());
                throw;
            }
        }
Exemple #7
0
        //To Perform Insert,Update,Delete and Search Actions On Leave Table
        #region [Perform Actions On Leave]

        public int LeaveAction_DL(EWA_LeaveType objEWA)
        {
            try
            {
                cmd             = new SqlCommand("SP_Leave", con);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@Action", objEWA.Action);
                cmd.Parameters.AddWithValue("@LeaveId", objEWA.LeaveId);
                cmd.Parameters.AddWithValue("@LeaveName", objEWA.LeaveName);
                cmd.Parameters.AddWithValue("@LeaveCode", objEWA.LeaveCode);
                cmd.Parameters.AddWithValue("@LeaveCount", objEWA.LeaveCount);
                cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
                cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
                cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
                con.Open();
                int flag = cmd.ExecuteNonQuery();
                con.Close();
                return(flag);
            }
            catch (Exception ex)
            {
                int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
                if (err == 547 && objEWA.Action == "Delete")
                {
                    throw new SystemException("Record is in use !!!");
                }
                else
                {
                    throw ex;
                }
            }
            finally
            {
                con.Close();
                cmd.Dispose();
            }
        }