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