public ActionResult Costs_TableView()
{
//Call services storeprocedure get list table service costs
using (var db = new HCB_ABBOTTEntities())
{
var list = db.Service_Criteria.ToList();
ViewData["list_service_costs"] = list;
}
ViewBag.Usr = Session["user"].ToString();
return(PartialView());
}
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
}));
}
}
public JsonResult Event_Add_Edit_Event_Info(string data)
{
AddEventInfoClass temp = JsonConvert.DeserializeObject <AddEventInfoClass>(data);
Message ms = new Message();
using (var db = new HCB_ABBOTTEntities())
{
//add event
#region event
Event_Info ei = new Event_Info();
ei.Abbott_Code = temp.form["Abbott_Code"];
ei.Id_Admin_Info = Int32.Parse(temp.form["Id_Admin_Info"]);
ei.Name = temp.form["Name"];
ei.Event_Time = DateTime.Parse(temp.form["Event_Time"]);
ei.Request_Date = DateTime.Parse(temp.form["Request_Date"]);
ei.Area = temp.form["Area"];
ei.Description = temp.form["Description"];
ei.Note = temp.form["Note"];
ei.Status = "Actived";
ei.Create_Date = DateTime.Now;
ei.Create_User = temp.form["CreateUser"];
db.Event_Info.Add(ei);
db.SaveChanges();
#endregion
//add s cost
#region add sv cost
string usr = Session["user"].ToString();
int id_username = db.UserNames.FirstOrDefault(r => r.UserName1 == usr).ID;
for (int i = 1; i <= 8; i++)
{
var fee = temp.FeeJson[i.ToString()];
Service_Cost sc = new Service_Cost();
sc.ID_Event = ei.ID;
sc.ID_Service_Criteria = i;
sc.Honorarium_fee = fee.Fee;
sc.Air_ticket = temp.TicketJson[i.ToString()].Tickets;
sc.Meal_fee = temp.MealJson[i.ToString()].Meals;
sc.Hotel_fee = temp.HotelJson[i.ToString()].Hotels;
sc.Car_rental = temp.CarJson[i.ToString()].Cars;
sc.Other_fees = temp.OtherJson[i.ToString()].Others;
sc.Total_costs = double.Parse(temp.Totalrow[i - 1]);
db.Service_Cost.Add(sc);
db.SaveChanges();
}
#endregion
//add rate
#region add rate
//for (int i = 1; i <= 8; i++)
//{
// if (i==2 || i==4 || i==7) {
// User_Create_Rate us_cr = new User_Create_Rate();
// us_cr.Id_User_Name = id_username;
// us_cr.Rate = temp.RateJson[i.ToString()].Ratenames;
// us_cr.Status = "Actived";
// us_cr.Create_Date = DateTime.Now;
// us_cr.Create_User = temp.form["CreateUser"];
// if(i == 2) { us_cr.Id_rate = 1; }
// if (i == 4) { us_cr.Id_rate = 2; }
// if (i == 7) { us_cr.Id_rate = 3; }
// db.User_Create_Rate.Add(us_cr);
// db.SaveChanges();
// }
//}
#endregion
//add history payment
#region history payment
bool invoice_1 = false;
if (temp.form["Invoice_Abbott"].ToString() == "0")
{
invoice_1 = true;
}
History_Payment hp = new History_Payment();
hp.Id_Event = ei.ID;
hp.HCP_Code = temp.form["HCP_Code"];
hp.Number_Contract = temp.form["Number_Contract"];
hp.FromDate = DateTime.Parse(temp.form["FromDate"]);
hp.ToDate = DateTime.Parse(temp.form["ToDate"]);
hp.Value_Contract = double.Parse(temp.form["Value_Contract"]);
hp.PPL_GetContract_Date = DateTime.Parse(temp.form["PPL_GetContract_Date"]);
hp.Rep_Name = temp.form["Rep_Name"];
hp.Sup_Name = temp.form["Sup_Name"];
hp.Description = temp.form["Description"];
//hp.Requested_Value = double.Parse(temp.form["Requested_Value"]);
//hp.Requested_Date = DateTime.Parse(temp.form["Requested_Date"]);
hp.PPL_Payment_Date = DateTime.Parse(temp.form["PPL_Payment_Date"]);
hp.Payment_Value = double.Parse(temp.form["Payment_Value"]);
hp.Invoice_Abbott = invoice_1;
hp.Report_Abbott_Date = DateTime.Parse(temp.form["Report_Abbott_Date"]);
//hp.Account_Name = temp.form["Account_Name"];
hp.Note = temp.form["Note"];
hp.Status = "Actived";
hp.Create_User = temp.form["CreateUser"];
hp.Create_Date = DateTime.Now;
db.History_Payment.Add(hp);
db.SaveChanges();
#endregion
ms.code = "0";
ms.msg = "Thêm Thành Công !";
}
Session["idEvent"] = ms.sub_code;
return(Json(ms));
}
