internal DataTable DL_SaveTransMaster(PL_LeaveTrasaction plobj)
 {
     try
     {
         con             = Connection.SetConnection();
         cmd             = new SqlCommand("SPLeaveTransaction", con);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.AddWithValue("@Ind", plobj.Ind);
         cmd.Parameters.AddWithValue("@CITYCODE", plobj.CityCode);
         cmd.Parameters.AddWithValue("@empno", plobj.Empno);
         cmd.Parameters.AddWithValue("@LvCd", plobj.LvCd);
         cmd.Parameters.AddWithValue("@NoOfLv", plobj.NoOfLv);
         cmd.Parameters.AddWithValue("@DateFrom", plobj.DateFrom);
         cmd.Parameters.AddWithValue("@DateTo", plobj.DateTo);
         cmd.Parameters.AddWithValue("@month", plobj.Month);
         cmd.Parameters.AddWithValue("@Upd_Ind", plobj.Upd_Ind);
         cmd.Parameters.AddWithValue("@Narr", plobj.Narr);
         da = new SqlDataAdapter(cmd);
         dt = new DataTable();
         da.Fill(dt);
         return(dt);
     }
     catch { return(dt); }
     finally
     {
         con.Close();
         con.Dispose();
     }
 }
        public DataTable UpdateData(PL_LeaveTrasaction plobj)
        {
            DL_LeaveTrasaction objdl = new DL_LeaveTrasaction();
            DataTable          dt    = new DataTable();

            if (plobj.Ind == 0)
            {
                return(dt);
            }
            else
            {
                dt = objdl.DL_SaveTransMaster(plobj);
                return(dt);
            }
        }