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);
}
