public ActionResult HCP_TableView(string province) { //Call services storeprocedure get list table HCB var list = ServiceStoreProduce.Instance().Get_List_HCP_Info(province); ViewData["list_hcp_info"] = list; return(PartialView()); }
public ActionResult History_Payment_By_Event_Table() { int idEvent = int.Parse(Session["idEventInfo"].ToString()); var list = ServiceStoreProduce.Instance() .Get_List_History_Payment_By_Event(idEvent); ViewData["history_payment"] = list; return(PartialView()); }
public ActionResult Event_Info_Table(string requestTime, string eventTime) { if (Session["user"] != null) { var temp = ServiceStoreProduce.Instance().Get_List_Event_Info(requestTime, eventTime); ViewData["list_event_info"] = temp; return(PartialView()); } else { ViewBag.Msg = "Phiên làm việc của bạn đã hết hạn, vui lòng đăng nhập lại để tiếp tục!!"; return(RedirectToAction("Index", "GUI")); } }
public JsonResult Select_List_Place_Issue(string text, string value) { var temp = ServiceStoreProduce.Instance().List_Select_Place_Issue().ToList(); List <SelectListItem> list = new List <SelectListItem>(); foreach (var item in temp) { list.Add(new SelectListItem { Text = item, Value = item }); } return(Json(list)); }
public JsonResult getRate_ByUsr(string usr) { try { var temp = ServiceStoreProduce.Instance().GetRate_ByUsr(usr); User_Create_Rate rate2 = null, rate4 = null, rate7 = null; var list_rate2 = temp.Where(r => r.Id_rate == 1).ToList(); var list_rate4 = temp.Where(r => r.Id_rate == 2).ToList(); var list_rate7 = temp.Where(r => r.Id_rate == 3).ToList(); if (list_rate2.Count > 0) //nneu co { rate2 = list_rate2.OrderByDescending(o => o.Create_Date).FirstOrDefault(); } else { using (var db = new HCB_ABBOTTEntities()) { #region rate 2 int id_user = db.UserNames.Where(r => r.UserName1 == usr).FirstOrDefault().ID; var rate_obj = db.Rates.Where(r => r.ID == 1).FirstOrDefault(); double?rate_string = rate_obj.Rate_Value; int id_rate = rate_obj.ID; rate2 = db.User_Create_Rate.Add(new User_Create_Rate() { Id_rate = id_rate, Id_User_Name = id_user, Create_Date = DateTime.Now, Create_User = usr, Rate = rate_string, Status = "Actived" }); db.SaveChanges(); }; #endregion } //rate 4 if (list_rate4.Count > 0) //nneu co { rate4 = list_rate4.OrderByDescending(o => o.Create_Date).FirstOrDefault(); } else { using (var db = new HCB_ABBOTTEntities()) { #region rate 4 int id_user = db.UserNames.Where(r => r.UserName1 == usr).FirstOrDefault().ID; var rate_obj = db.Rates.Where(r => r.ID == 2).FirstOrDefault(); double?rate_string = rate_obj.Rate_Value; int id_rate = rate_obj.ID; rate4 = db.User_Create_Rate.Add(new User_Create_Rate() { Id_rate = id_rate, Id_User_Name = id_user, Create_Date = DateTime.Now, Create_User = usr, Rate = rate_string, Status = "Actived" }); db.SaveChanges(); }; #endregion } //rate 7 if (list_rate7.Count > 0) //nneu co { rate7 = list_rate7.OrderByDescending(o => o.Create_Date).FirstOrDefault(); } else { using (var db = new HCB_ABBOTTEntities()) { #region rate 7 int id_user = db.UserNames.Where(r => r.UserName1 == usr).FirstOrDefault().ID; var rate_obj = db.Rates.Where(r => r.ID == 3).FirstOrDefault(); double?rate_string = rate_obj.Rate_Value; int id_rate = rate_obj.ID; rate7 = db.User_Create_Rate.Add(new User_Create_Rate() { Id_rate = id_rate, Id_User_Name = id_user, Create_Date = DateTime.Now, Create_User = usr, Rate = rate_string, Status = "Actived" }); db.SaveChanges(); }; #endregion } return(Json(new { code = HttpStatusCode.OK.ToString(), rate_2 = rate2, rate_4 = rate4, rate_7 = rate7 })); } catch (Exception e) { return(Json(new { code = HttpStatusCode.NotFound.ToString(), data = e.Message })); } }