public bool AddCompany(Company company)
{
context1.Company.Add(company);
int RowsAdded = context1.SaveChanges();
return(RowsAdded > 0);
}
public IActionResult EditRequest(TrinerRequestModel model, int Id)
{
var base64 = "";
if (model.Avatar != null)
{
var tempImage = System.Drawing.Image.FromStream(model.Avatar.OpenReadStream());
var result = Utility.ResizeImage(tempImage, 308, 173);
base64 = string.Format("data:image/jpg; base64, {0}", Convert.ToBase64String(Utility.ImageToByte2(result)));
model.UserImage = base64;
}
var request = _context.TrinerRequests.FirstOrDefault(p => p.Id == Id);
request.Name = model.Name;
request.SurName = model.SurName;
request.Phone = model.Phone;
request.Email = string.IsNullOrEmpty(model.Email) ? string.Empty : model.Email;
request.About = model.About;
request.MyRequest = model.MyRequest;
request.Accept = true;
request.Avatar = string.IsNullOrEmpty(model.UserImage) ? request.Avatar : base64;
_context.TrinerRequests.Update(request);
_context.SaveChanges();
return(RedirectToAction("TrinerRequestIndex"));
}
public void TestShopSaleReadProperly()
{
//SETUP
var options = SqliteInMemory.CreateOptions <CompanyDbContext>();
using (var context = new CompanyDbContext(options, new FakeGetClaimsProvider("accessKey*")))
{
context.Database.EnsureCreated();
var company = Company.AddTenantToDatabaseWithSaveChanges("TestCompany", PaidForModules.None, context);
var shop = RetailOutlet.AddTenantToDatabaseWithSaveChanges("TestShop", company, context);
var shopStock = new ShopStock {
Name = "dress", RetailPrice = 12, NumInStock = 2, Shop = shop
};
context.Add(shopStock);
context.SaveChanges();
//ATTEMPT
var status = ShopSale.CreateSellAndUpdateStock(1, shopStock.ShopStockId, context);
status.IsValid.ShouldBeTrue(status.GetAllErrors());
context.Add(status.Result);
context.SaveChanges();
//VERIFY
var salesNotFiltered = context.ShopSales.IgnoreQueryFilters()
.Include(x => x.StockItem).ThenInclude(x => x.Shop)
.ToList();
salesNotFiltered.Count.ShouldEqual(1);
salesNotFiltered.First().StockItem.ShouldNotBeNull();
salesNotFiltered.First().StockItem.Shop.ShouldNotBeNull();
}
}
public ActionResult Create([Bind(Include = "ProductID, ProductName, Price, DOP, AvailabilityStatus, CategoryID, BrandID, Active, Photo")] Product product)
{
//var db = new EFDBFirstDatabaseEntities();
if (!ModelState.IsValid)
{
ViewBag.Categories = db.Categories.ToList();
ViewBag.Brands = db.Brands.ToList();
return(View());
}
if (Request.Files.Count >= 1)
{
var file = Request.Files[0];
//doesn't work
//var imgBytes = new Byte[file.ContentLength - 1];
var imgBytes = new Byte[file.ContentLength];
file.InputStream.Read(imgBytes, 0, file.ContentLength);
var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length);
product.Photo = base64String;
}
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(Employees Emp, List <Education> education)
{
if (ModelState.IsValid)
{
Employees existingEmp = Db.Employees.Where(m => m.EmpId == Emp.EmpId).FirstOrDefault();
existingEmp.EmpName = Emp.EmpName;
existingEmp.EmpEmailId = Emp.EmpEmailId;
for (int i = 0; i < existingEmp.EmpEdu.Count(); i++)
{
existingEmp.EmpEdu[i].EduLevel = Emp.EmpEdu[i].EduLevel;
existingEmp.EmpEdu[i].EduYOP = Emp.EmpEdu[i].EduYOP;
}
for (int i = existingEmp.EmpEdu.Count; i < Emp.EmpEdu.Count(); i++)
{
existingEmp.EmpEdu.Add(Emp.EmpEdu[i]);
existingEmp.EmpEdu[i].EduLevel = Emp.EmpEdu[i].EduLevel;
existingEmp.EmpEdu[i].EduYOP = Emp.EmpEdu[i].EduYOP;
}
existingEmp.EmpEdu = Emp.EmpEdu;
Db.SaveChanges();
TempData["success"] = "The employee has been successfully added";
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public bool AddIpo(Ipo ipo)
{
context.Ipo.Add(ipo);
int RowsAdded = context.SaveChanges();
return(RowsAdded > 0);
}
public void DeleteDatabase(int id)
{
var item = _context.RegistrationRequests.FirstOrDefault(p => p.Id == id);
_context.RegistrationRequests.Remove(item);
_context.SaveChanges();
}
public bool AddStockPrice(StockPrice stockPrice)
{
context.StockPrice.Add(stockPrice);
int RowsAdded = context.SaveChanges();
return(RowsAdded > 0);
}
public IActionResult DeleteReview(int Id)
{
var review = _context.Reviews.FirstOrDefault(p => p.Id == Id);
_context.Reviews.Remove(review);
_context.SaveChanges();
return(RedirectToAction("Review"));
}
public IActionResult DeleteProblem(int Id)
{
var problem = _context.Problems.FirstOrDefault(p => p.Id == Id);
_context.Problems.Remove(problem);
_context.SaveChanges();
return(RedirectToAction("ProblemIndex"));
}
public IActionResult AddDepartment(Department newDepartment)
{
if (ModelState.IsValid)
{
_context.Departments.Add(newDepartment);
_context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public IActionResult AddEmployee(Employee employee)
{
employee.DepartmentId = 1;
if (ModelState.IsValid)
{
_context.Employees.Add(employee);
_context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public CompanyDTO AddCompany(AddCompanyDTO companyDto)
{
var company = mapper.Map <Company>(companyDto);
dbContext.Add(company);
dbContext.SaveChanges();
var result = mapper.Map <CompanyDTO>(company);
return(result);
}
public ActionResult Create([Bind(Include = "ID,Image,DisplayOrder,Link,Description,CreateDate,CreateBy,ModifiedDate,ModifiedBy,Status")] Slide slide)
{
if (ModelState.IsValid)
{
db.Slides.Add(slide);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(slide));
}
public ActionResult Create([Bind(Include = "ID,Name,Description,Detail,Image,CreateDate,CreateBy,ModifiedDate,ModifiedBy,Status")] About about)
{
if (ModelState.IsValid)
{
db.Abouts.Add(about);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(about));
}
public ActionResult Create([Bind(Include = "ID,Text,Link,DisplayOrder,Target,Status,TypeID")] Menu menu)
{
if (ModelState.IsValid)
{
db.Menus.Add(menu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(menu));
}
public ActionResult Create([Bind(Include = "ID,Content,Status")] Footer footer)
{
if (ModelState.IsValid)
{
db.Footers.Add(footer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(footer));
}
public ActionResult Create([Bind(Include = "ID,Name,Description,Detail,Status,CreateDate,CreateBy,ModifiedDate,ModifiedBy,ShowOnHome")] CategoryNew categoryNew)
{
if (ModelState.IsValid)
{
db.CategoryNews.Add(categoryNew);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoryNew));
}
public ActionResult Create([Bind(Include = "ID,Name,Phone,Email,Address,CreateDate,CreateBy,ModifiedDate,ModifiedBy,Content,Status")] Feedback feedback)
{
if (ModelState.IsValid)
{
db.Feedbacks.Add(feedback);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(feedback));
}
public ActionResult Create([Bind(Include = "ID,Name")] MenuType menuType)
{
if (ModelState.IsValid)
{
db.MenuTypes.Add(menuType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(menuType));
}
public ActionResult Create([Bind(Include = "ID,Name")] UserGroup userGroup)
{
if (ModelState.IsValid)
{
db.UserGroups.Add(userGroup);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userGroup));
}
public ActionResult Create([Bind(Include = "UserGroupID,RoleID")] Credential credential)
{
if (ModelState.IsValid)
{
db.Credentials.Add(credential);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(credential));
}
public ActionResult Create([Bind(Include = "ID,Content,Status")] Contact contact)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
public ActionResult Create([Bind(Include = "ID,Name,Description,Image,Detail,Status,CreateDate,CreateBy,ModifiedDate,ModifiedBy,CategoryServicesID")] Service service)
{
if (ModelState.IsValid)
{
service.CreateDate = DateTime.Now;
db.Services.Add(service);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(service));
}
public void AddEmployee(int companyId, AddEmployeeDTO employeeDto)
{
var employee = mapper.Map <Employee>(employeeDto);
var company = dbContext.Companies
.FirstOrDefault(c => c.Id == companyId && c.IsActive);
if (company != null)
{
company.Employees.Add(employee);
dbContext.SaveChanges();
}
}
public List <ChatRoomsModel> GetChatRooms()
{
var id = _context.RegistrationRequests.FirstOrDefault(a => a.Email == User.Identity.Name).Id;
List <ChatRoom> foundWithCurrentUserIdRoom = _context.CharRooms.Where(a => (a.CurrentUserId == id)).OrderByDescending(a => a.LastModifiedOn).ToList();
List <ChatRoom> foundInToIdRoom = _context.CharRooms.Where(a => a.ToUserId == id).OrderByDescending(a => a.LastModifiedOn).ToList();
List <ChatRoomsModel> result = new List <ChatRoomsModel>();
foreach (var item in foundWithCurrentUserIdRoom)
{
var user = _context.RegistrationRequests.FirstOrDefault(a => a.Id == item.ToUserId);
if (user == null)
{
_context.CharRooms.Remove(item);
_context.SaveChanges();
continue;
}
ChatRoomsModel model = new ChatRoomsModel();
model.ChatRoomId = item.Id;
model.ToUserUserName = user.Email;
model.Image = user.Image;
model.ChatRoomData = item.LastModifiedOn;
result.Insert(0, model);
}
foreach (var item in foundInToIdRoom)
{
var user = _context.RegistrationRequests.FirstOrDefault(a => a.Id == item.CurrentUserId);
if (user == null)
{
_context.CharRooms.Remove(item);
_context.SaveChanges();
continue;
}
ChatRoomsModel model = new ChatRoomsModel();
model.ChatRoomId = item.Id;
model.ToUserUserName = user.Email;
model.Image = user.Image;
model.ChatRoomData = item.LastModifiedOn;
result.Insert(0, model);
}
//return View(result);
return(result);
}
public ActionResult Create(Product p)
{
if (Request.Files.Count >= 1)
{
var file = Request.Files[0];
var imgBytes = new Byte[file.ContentLength];
file.InputStream.Read(imgBytes, 0, file.ContentLength);
var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length);
p.Photo = base64String;
}
db.Products.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int Create(News news)
{
//Xử lý alias
if (string.IsNullOrEmpty(news.MetaTitle))
{
news.MetaTitle = StringHelper.ToUnsignString(news.Name);
}
news.CreateDate = DateTime.Now;
news.ModifiedDate = DateTime.Now;
db.News.Add(news);
db.SaveChanges();
return(news.ID);
}
public bool Delete(int id)
{
try
{
var menu = db.Menus.Find(id);
menu.Deleted = true;
menu.ModifiedDate = DateTime.Now;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public IActionResult Post([FromForm] Administrator admin)
{
if (admin.Name == "初始化管理员")
{
throw new Exception("初始化管理员为系统保留名称，不允许使用，请更换");
}
admin.Id = admin.Id.ToLower();
if (context.Administrator.Any(a => a.Id == admin.Id))
{
throw new Exception(String.Format("登录用户名为 ‘{0}’ 的管理员已存在，请更换", admin.Id));
}
if (context.Administrator.Any(a => a.Name == admin.Name))
{
throw new Exception(String.Format("名称为 ‘{0}’ 的管理员已存在，请更换", admin.Name));
}
//admin.Password = Administrator.ConvertPassword(admin.Password);
admin.PasswordChangeTime = DateTime.Now.ToUniversalTime();
context.Administrator.Add(admin);
context.SaveChanges();
return(Ok());
}
//[ValidateAntiForgeryToken]
public async Task<ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
string org_name = model.CompanyName.Replace(' ', '_');
FileWorker.CreateCompanyRepo(org_name);
var user = new ApplicationUser { UserName = model.Email, Email = model.Email, Name = org_name, RegisterDate = DateTime.Now, NextPayment = DateTime.Now.AddMonths(1) };
var result = await UserManager.CreateAsync(user, model.Password);
var CompanyDb = new CompanyDbContext(org_name);
var fio = model.FIO.Split(' ');
CompanyDb.Employees.Add(new Employee() { Surname = fio[0], Name = fio[1], Patronymic = fio[2], Login = model.Email, Password = "" });
CompanyDb.SaveChanges();
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false);
// Дополнительные сведения о том, как включить подтверждение учетной записи и сброс пароля, см. по адресу: http://go.microsoft.com/fwlink/?LinkID=320771
// Отправка сообщения электронной почты с этой ссылкой
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Подтверждение учетной записи", "Подтвердите вашу учетную запись, щелкнув <a href=\"" + callbackUrl + "\">здесь</a>");
return Json(Url.Action("Index", "MainPage"));
}
}
return GetErrors();
}