コード例 #1
0
        public DataSet BindGridView(DTO.Holiday Ob)
        {
            SqlCommand cmd = new SqlCommand();
            DataSet    ds  = new DataSet();

            cmd.CommandText = "Sp_holiday";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@description", Ob.description);
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 3);
            ds = PrjClass.GetData(cmd);
            return(ds);
        }
コード例 #2
0
        public string UpdateWeekend(DTO.Holiday Ob)
        {
            ArrayList  date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BranchId);
            string     res  = string.Empty;
            SqlCommand cmd  = new SqlCommand();

            cmd.CommandText = "Sp_holiday";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@weeklyoff", Ob.weeklyoff);
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 5);
            res = PrjClass.ExecuteNonQuery(cmd);
            return(res);
        }
コード例 #3
0
        public string deleteHolidayMaster(DTO.Holiday Ob)
        {
            string     res = string.Empty;
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Sp_holiday";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Active", Ob.Active);
            cmd.Parameters.AddWithValue("@holidayid", Ob.holidayid);
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 4);
            res = PrjClass.ExecuteNonQuery(cmd);
            return(res);
        }
コード例 #4
0
        public string UpdateHolidayMaster(DTO.Holiday Ob)
        {
            ArrayList  date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BranchId);
            string     res  = string.Empty;
            SqlCommand cmd  = new SqlCommand();

            cmd.CommandText = "Sp_holiday";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@description", Ob.description);
            cmd.Parameters.AddWithValue("@date", Ob.date);
            cmd.Parameters.AddWithValue("@holidayid", Ob.holidayid);
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 2);
            res = PrjClass.ExecuteNonQuery(cmd);
            return(res);
        }
コード例 #5
0
 public string SaveHolidayMaster(DTO.Holiday Ob)
 {
     return(DAL.DALFactory.Instance.DAL_HolidayMaster.SaveHolidayMaster(Ob));
 }
コード例 #6
0
 public string UpdateWeekend(DTO.Holiday Ob)
 {
     return(DAL.DALFactory.Instance.DAL_HolidayMaster.UpdateWeekend(Ob));
 }
コード例 #7
0
 public DataSet BindGridView(DTO.Holiday Ob)
 {
     return(DAL.DALFactory.Instance.DAL_HolidayMaster.BindGridView(Ob));
 }