public void Post([FromBody] InspectionPlanEventViewModel model)
{
//System.Console.WriteLine("LOOP: " + model.Name);
//System.Console.WriteLine("Input: " + model.input);
//return model.input;
var date = DateTime.Now;
//var inspectionplanevent = new InspectionPlanEvent
//{
// CreatedAt = date,
// CreatedBy = "NIK"
//};
//_context.InspectionPlanEvents.Add(inspectionplanevent);
//_context.SaveChanges();
foreach (var item2 in model.input)
{
//foreach (var item3 in item2.ProvinceId)
//{
var check = _context.InspectionPlanEvents
.Where(x => x.CreatedBy == model.CreatedBy &&
x.StartDate == item2.StartPlanDate &&
x.EndDate == item2.EndPlanDate &&
x.ProvinceId == item2.ProvinceId)
.Select(x => x.CreatedBy)
.FirstOrDefault();
System.Console.WriteLine("check: " + check);
if (check == null)
{
System.Console.WriteLine("no inspectionplanevent, create new");
var inspectionplanevent = new InspectionPlanEvent
{
StartDate = item2.StartPlanDate,
EndDate = item2.EndPlanDate,
ProvinceId = item2.ProvinceId,
CreatedAt = date,
CreatedBy = model.CreatedBy,
};
_context.InspectionPlanEvents.Add(inspectionplanevent);
_context.SaveChanges();
}
else
{
System.Console.WriteLine("already have inspectionplanevent, don't create");
}
//var centralpolicyeventdata = new CentralPolicyEvent
//{
// CentralPolicyId = item2.CentralPolicyId,
// InspectionPlanEventId = inspectionplanevent.Id
//};
// _context.CentralPolicyEvents.Add(centralpolicyeventdata);
// _context.SaveChanges();
//}
}
}
public object Post(long provinceid, string userid, DateTime start_date_plan, DateTime end_date_plan)
{
var date = DateTime.Now;
var InspectionPlanEventdata = new InspectionPlanEvent
{
ProvinceId = provinceid,
CreatedAt = date,
CreatedBy = userid,
StartDate = start_date_plan,
EndDate = end_date_plan,
};
_context.InspectionPlanEvents.Add(InspectionPlanEventdata);
_context.SaveChanges();
return(InspectionPlanEventdata.Id);
}
public object Post(long provinceid, string userid, DateTime start_date_plan, DateTime end_date_plan)
{
var userdata = _context.Users
.Where(m => m.Id == userid)
//.Select(m => m.Role_id)
.FirstOrDefault();
var date = DateTime.Now;
var InspectionPlanEventdata = new InspectionPlanEvent
{
ProvinceId = provinceid,
CreatedAt = date,
CreatedBy = userid,
StartDate = start_date_plan,
EndDate = end_date_plan,
Status = "ร่างกำหนดการ",
RoleCreatedBy = userdata.Role_id.ToString(),
ProvincialDepartmentIdCreatedBy = userdata.ProvincialDepartmentId,
};
_context.InspectionPlanEvents.Add(InspectionPlanEventdata);
_context.SaveChanges();
var logdata = new Log
{
UserId = userid,
DatabaseName = "InspectionPlanEvent",
EventType = "เพิ่ม",
EventDate = date,
Detail = "เพิ่มกำหนดการตรวจราชการ",
Allid = InspectionPlanEventdata.Id,
};
_context.Logs.Add(logdata);
_context.SaveChanges();
return(InspectionPlanEventdata.Id);
}
