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