public void Execute()
{
try
{
lock (_lock)
{
var oldEntities = _dbContext.Events.Where(e => e.Time < DateTime.UtcNow.AddMonths(-3));
if (oldEntities != null && oldEntities.Count() > 0)
{
_dbContext.Events.RemoveRange(oldEntities);
}
_dbContext.SaveChanges();
var oldCIEntities = _dbContext.ContactInfoEvents.Where(e => e.Time < DateTime.UtcNow.AddMonths(-3));
if (oldCIEntities != null && oldCIEntities.Count() > 0)
{
_dbContext.ContactInfoEvents.RemoveRange(oldCIEntities);
}
_dbContext.SaveChanges();
}
}
finally
{
}
}
public ActionResult Create(Service service)
{
if (ModelState.IsValid)
{
db.Services.Add(service);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(service));
}
public ActionResult Create([Bind(Include = "ID,firstName,lastName,address,homePhone,cellPhone,alternatePhone")] Client client)
{
if (ModelState.IsValid)
{
db.Clients.Add(client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(client));
}
public void Create(CreateOrderDTO dto)
{
var order = new Order
{
Description = dto.Description,
Model = dto.Model,
CustomerId = 1
};
_dbContext.Orders.Add(order);
_dbContext.SaveChanges();
}
public void Execute()
{
try
{
Logger.LogError("Start to execute Calculate");
lock (_lock)
{
var currentTime = DateTime.UtcNow;
var result = CalculateProcessor.Calculate();
_dbContext.Events.Add(new Event()
{
EventName = "Calculate",
Id = Guid.NewGuid(),
Time = currentTime,
Timeout = Convert.ToInt32(result.Time),
IsError = result.IsError
});
_dbContext.SaveChanges();
}
}
finally
{
}
}
protected override void doAfter(IList <ServiceInfo> data)
{
using (var ef = new ServiceDBContext())
{
ef.ServiceInfo.UpdateRange(data);
int c = ef.SaveChanges();
logger.Info($"doAfter save:{c}/{data.Count}");
}
}
public bool AddDepartment(DepartmentViewModel model)
{
try
{
Department department = new Department
{
DepartmentId = model.DepartmentId,
DepartmentName = model.DepartmentName
};
_Context.Department.Add(department);
_Context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public void Seed()
{
if (_dbContext.Database.CanConnect())
{
if (!_dbContext.Orders.Any())
{
var orders = GetOrders();
_dbContext.Orders.AddRange(orders);
_dbContext.SaveChanges();
}
}
}
public bool AddMembers(MembersViewModel model)
{
string MemberDigitalAddress;
try
{
if (model.DigitalAddress == null)
{
MemberDigitalAddress = "None";
model.DigitalAddress = MemberDigitalAddress;
}
else
{
MemberDigitalAddress = model.DigitalAddress;
}
Members members = new Members
{
FullName = model.FullName.ToUpper(),
Age = model.Age,
GenderId = model.GenderId,
Residence = model.Residence,
DigitalAddress = MemberDigitalAddress,
PhoneNumber = model.PhoneNumber,
DepartmentId = model.DepartmentId,
CurrentDate = DateTime.Now
};
_Context.Members.Add(members);
_Context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Create([Bind(Include = "ID,S_Name,S_Path,Pic_Path,S_User,S_Pwd,S_CreatTime,S_LastTime,S_Admin,S_Remark")] Service service, HttpPostedFileBase Pic)
{
//上传图片
if (Pic != null)
{
var fileName = Pic.FileName;
var filePath = Server.MapPath(string.Format("~/{0}", "File"));
service.Pic_Path = "/File/" + fileName;
Pic.SaveAs(Path.Combine(filePath, fileName));
}
//获取创建和修改时间
service.S_CreatTime = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString();
service.S_LastTime = service.S_CreatTime;
//
if (ModelState.IsValid)
{
db.Services.Add(service);
db.SaveChanges();
return(RedirectToAction("Inf"));
}
return(View(service));
}
public bool AddTemperature(TemperatureViewModel model)
{
try
{
Temperature temperature = new Temperature
{
MemberId = model.MemberId,
TempuratureNumber = model.TempuratureNumber,
CurrentDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()),
VerifyId = model.VerifyId
};
_Context.Temperature.Add(temperature);
_Context.SaveChanges();
return(true);
}
catch (Exception)
{
throw new Exception();
}
}
public bool UpdateVerifyMember(VerifyMemberViewModel model)
{
try
{
VerifyMember verify = _Context.VerifyMember.Where(x => x.VerifyId == model.VerifyId).FirstOrDefault();
verify.VerifyId = model.VerifyId;
verify.VerifyName = model.VerifyName;
_Context.VerifyMember.Update(verify);
_Context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
// GET: Copyrights/Create
public ActionResult Create()
{
if (Thread.CurrentPrincipal.Identity.IsAuthenticated)
{
Copyright newCop = new Copyright();
db.Copyrights.Add(newCop);
db.SaveChanges();
return(RedirectToAction("Edit", "Copyrights", new { id = newCop.CopyrightID }));
}
else
{
string model = "You must be authenticated for this action. Please log in.";
return(View("~/Views/Shared/WriteStringView.cshtml", model: model));
}
}
public async Task Consume(ConsumeContext <PostUserRequest> context)
{
DbUser newUser = new DbUser()
{
Id = Guid.NewGuid(),
Name = context.Message.User.Name,
Nickname = context.Message.User.Nickname
};
var dbContext = new ServiceDBContext(new DbContextOptions <ServiceDBContext>());
dbContext.Add(newUser);
dbContext.SaveChanges();
await context.RespondAsync <PostUserResponse>(new PostUserResponse()
{
Id = newUser.Id
});
}
// GET: Applications/Create
public ActionResult Create()
{
if (Thread.CurrentPrincipal.Identity.IsAuthenticated)
{
Application newApp = new Application();
db.Applications.Add(newApp);
db.SaveChanges();
//send existing Application to Edit method
return(RedirectToAction("Edit", "Applications", new { id = newApp.ApplicationID }));
}
else
{
string model = "You must be authenticated for this action. Please log in.";
return(View("~/Views/Shared/WriteStringView.cshtml", model: model));
}
}
public void Execute()
{
try
{
lock (_lock)
{
var currentTime = DateTime.UtcNow;
var result = ContactInfoProcessor.ContactInfo();
_dbContext.Events.Add(new Event()
{
EventName = "ContactInfo",
Id = Guid.NewGuid(),
Time = currentTime,
Timeout = Convert.ToInt32(result.Time),
IsError = result.IsError
});
_dbContext.SaveChanges();
}
}
finally
{
}
}
public void ResetDB()
{
List <Director> ds = db.Directors.ToList();
foreach (Director d in ds)
{
db.Directors.Remove(d);
}
db.SaveChanges();
List <Film> fs = db.Films.ToList();
foreach (Film f in fs)
{
db.Films.Remove(f);
}
db.SaveChanges();
FilmInfoInitializer.Populate(db);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ServiceDBContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
if (!context.Servicios.Any())
{
context.Servicios.AddRange(new List <Servicio>()
{
new Servicio()
{
codigoServicio = 20,
nombreServicio = "NombreServicio20",
descripcion = "DescripcionServicio20"
},
new Servicio()
{
codigoServicio = 21,
nombreServicio = "NombreServicio21",
descripcion = "DescripcionServicio21"
},
new Servicio()
{
codigoServicio = 22,
nombreServicio = "NombreServicio22",
descripcion = "DescripcionServicio22"
},
new Servicio()
{
codigoServicio = 23,
nombreServicio = "NombreServicio23",
descripcion = "DescripcionServicio23"
},
new Servicio()
{
codigoServicio = 24,
nombreServicio = "NombreServicio24",
descripcion = "DescripcionServicio24"
},
new Servicio()
{
codigoServicio = 25,
nombreServicio = "NombreServicio25",
descripcion = "DescripcionServicio25"
}
});
context.SaveChanges();
}
}
