public string RegisterService(int reg_service, string reg_datebegin, string reg_number, string reg_name, string reg_email, string reg_phone, string reg_note, string reg_user, string menuId, string menu, string voucher, string reg_table) { string ecode, edesc; TB_REGISTERSSql sql = new TB_REGISTERSSql(); sql.SelectFromStore(out ecode, out edesc, AppSettingKeys.SP_REGISTER, reg_service, reg_datebegin, reg_number, reg_name, reg_email, reg_phone, menuId, reg_note, reg_user, menu, voucher, reg_table); return(ecode); }
public List <TB_REGISTERS> GetAllBy(string keyText, string startDate, string endDate, string total, string serviceId, string status, int pageNumber, int pageSize, out int count) { List <TB_REGISTERS> list = new List <TB_REGISTERS>(); object cTemp; TB_REGISTERSSql sql = new TB_REGISTERSSql(); list = sql.SelectFromStoreOutParam(AppSettingKeys.SP_REGISTER_GET_ALL_BY, out cTemp, keyText, startDate, endDate, total, serviceId, status, pageNumber, pageSize); count = (int)cTemp; return(list); }
public bool UpdateStatus(int registerId, string status) { string ecode, edesc; TB_REGISTERSSql sql = new TB_REGISTERSSql(); sql.SelectFromStore(out ecode, out edesc, AppSettingKeys.SP_UPDATE_STATUS_SERVICE, registerId, status); if (ecode.Equals("00")) { return(true); } else { return(false); } }
public string Insert(TB_REGISTERS register) { string result = ""; List <V_NUMBER_STUDIES> list = new List <V_NUMBER_STUDIES>(); list = new TB_SCHEDULESFactory().GetCountStudieInClass(register.RegisterScheduleId.ToString()); // lay ra danh sach lich hoc cua hoc sinh List <V_TKBStudies> listTKB = new List <V_TKBStudies>(); listTKB = new TB_USERSFactory().GetThoiKhoaBieu(register.RegisterUserId.ToString()); // lay ra danh sach thu trong tuan List <TB_SCHEDULE_DETAILS> listDetails = new List <TB_SCHEDULE_DETAILS>(); listDetails = new TB_SCHEDULE_DETAILSFactory().GetByScheduleId(register.RegisterScheduleId.ToString()); // lay danh sach da dang ky nhung chua duoc xac nhan List <TB_REGISTERS> listRegisTem = new List <TB_REGISTERS>(); listRegisTem = new TB_REGISTERSSql().FilterByField("RegisterUserId", register.RegisterUserId); bool check = true; foreach (var tkb in listRegisTem) { List <TB_SCHEDULE_DETAILS> listTemp = new List <TB_SCHEDULE_DETAILS>(); listTemp = new TB_SCHEDULE_DETAILSFactory().GetByScheduleId(tkb.RegisterScheduleId.ToString()); foreach (var a in listTemp) { if (listDetails.Where(x => x.ScheduleDetailId == a.ScheduleDetailId).ToList().Count == 0) { if (listDetails.Where(x => x.ScheduleDetailDayOfWeek.Equals(a.ScheduleDetailDayOfWeek) && x.ScheduleDetailTimeFrom.Hours == a.ScheduleDetailTimeFrom.Hours).ToList().Count > 0) { check = false; } } } } if (check) { bool check2 = true; foreach (var tkb in listTKB) { if (listDetails.Where(x => x.ScheduleDetailDayOfWeek.Equals(tkb.ScheduleDetailDayOfWeek) && x.ScheduleDetailTimeFrom.Hours == tkb.ScheduleDetailTimeFrom.Hours).ToList().Count > 0) { check2 = false; } } if (check2) { if (list.Count > 0) { if (list[0].CountStudie >= 20) { result = "150"; } else { List <TB_REGISTERS> listRegis = new List <TB_REGISTERS>(); listRegis = new TB_REGISTERSSql().FilterByField("RegisterUserId", register.RegisterUserId).Where(x => x.RegisterScheduleId == register.RegisterScheduleId).ToList(); if (listRegis.Count == 0) { if (new TB_REGISTERSSql().Insert(register)) { result = "00"; } else { result = "200"; } } else { result = "300"; } } } } else { result = "400"; } } else { result = "400"; } return(result); }