public bool SaveAccomodationType(AccomodationType newRecord)
{
db.AccomodationTypes.Add(newRecord);
return(db.SaveChanges() > 0);
}
public bool Add(Supplier supplier)
{
_dbContext.Suppliers.Add(supplier);
return(_dbContext.SaveChanges() > 0);
}
public bool Add(Product product)
{
_dbContext.Products.Add(product);
return(_dbContext.SaveChanges() > 0);
}
public ActionResult Create(Project project)
{
database.Projects.Add(project);
database.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
public bool Add(PurchasedProduct purchasedProduct)
{
_projectDbContext.PurchasedProducts.Add(purchasedProduct);
return(_projectDbContext.SaveChanges() > 0);
}
public void Add(Slider slider)
{
db.Sliders.Add(slider);
db.SaveChanges();
}
// public bool Add(SalesDetail salesDetail)
public bool Add(SalesDetail salesDetail)
{
_projectDbContext.SalesDetails.Add(salesDetail);
return(_projectDbContext.SaveChanges() > 0);
}
private void CreateRolesAndUsers()
{
//Admin role
var adminRole = _context.Roles.FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin);
if (adminRole == null)
{
adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin)
{
IsStatic = true
});
_context.SaveChanges();
//Grant all permissions to admin role
var permissions = PermissionFinder
.GetAllPermissions(new AppAuthorizationProvider(false))
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant))
.ToList();
foreach (var permission in permissions)
{
_context.Permissions.Add(
new RolePermissionSetting
{
TenantId = _tenantId,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
});
}
_context.SaveChanges();
}
//User role
var userRole = _context.Roles.FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.User);
if (userRole == null)
{
_context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.User, StaticRoleNames.Tenants.User)
{
IsStatic = true, IsDefault = true
});
_context.SaveChanges();
}
//admin user
var adminUser = _context.Users.FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == User.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**", "123qwe");
adminUser.IsEmailConfirmed = true;
adminUser.ShouldChangePasswordOnNextLogin = true;
adminUser.IsActive = true;
_context.Users.Add(adminUser);
_context.SaveChanges();
//Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id));
_context.SaveChanges();
//User account of admin user
if (_tenantId == 1)
{
_context.UserAccounts.Add(new UserAccount
{
TenantId = _tenantId,
UserId = adminUser.Id,
UserName = User.AdminUserName,
EmailAddress = adminUser.EmailAddress
});
_context.SaveChanges();
}
}
}
public void Add(Product product)
{
db.Products.Add(product);
db.SaveChanges();
}
public bool Add(Sales sales)
{
_dbContext.Saleses.Add(sales);
return(_dbContext.SaveChanges() > 0);
}
public bool Add(MajorOfBusiness majorOfBusiness)
{
_dbContext.MajorOfBusinesses.Add(majorOfBusiness);
return(_dbContext.SaveChanges() > 0);
}
public void Save()
{
_context.SaveChanges();
}
public void Add(DoctorContribution doctorContribution)
{
db.DoctorContributions.Add(doctorContribution);
db.SaveChanges();
}
public void Delete(VehicleMakeEntity entity)
{
context.VehicleMake.Remove(entity);
context.SaveChanges();
Console.WriteLine(entity.Make.Name);
}
public bool Add(Product product)
{
db.Products.Add(product);
return(db.SaveChanges() > 0);
}
public Project createProject(Project project)
{
_context.Projects.Add(project);
_context.SaveChanges();
return(project);
}
public bool Add(Category category)
{
_dbContext.Categories.Add(category);
return(_dbContext.SaveChanges() > 0);
}
public void Add(CustomerPayment customerPayment)
{
db.CustomerPayments.Add(customerPayment);
db.SaveChanges();
}
public ActionResult Add(VmProductAdd model)
{
TempData["SuccessMsg"] = "";
TempData["FailedMsg"] = "";
if (ModelState.IsValid)
{
try
{
if (db.Product.Any(a => a.ProductName == model.ProductName))
{
TempData["FailedMsg"] = "Product Already Exist";
}
else if (db.Product.Any(a => a.ProductCode == model.ProductCode))
{
TempData["FailedMsg"] = "Product Code Already Exist";
}
else
{
#region Image Upload
var uri = Request.Url.Host;
System.IO.Directory.CreateDirectory(Server.MapPath("~/Images/Product/" + uri));
string path = "";
if (model.Image1 != null)
{
string pic = System.IO.Path.GetFileName(model.Image1.FileName);
string physicalPath =
System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic);
path = "/Images/Product/" + uri + "/" + pic;
model.Image1.SaveAs(physicalPath);
model.ImageUrl1 = path;
}
path = "";
if (model.Image2 != null)
{
string pic = System.IO.Path.GetFileName(model.Image2.FileName);
string physicalPath =
System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic);
path = "/Images/Product/" + uri + "/" + pic;
model.Image2.SaveAs(physicalPath);
model.ImageUrl2 = path;
}
path = "";
if (model.Image3 != null)
{
string pic = System.IO.Path.GetFileName(model.Image3.FileName);
string physicalPath =
System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic);
path = "/Images/Product/" + uri + "/" + pic;
model.Image3.SaveAs(physicalPath);
model.ImageUrl3 = path;
}
#endregion
var newData = new Product();
newData.BrandId = model.BrandId;
newData.Description = model.Description;
newData.ModelNo = model.ModelNo;
newData.ProductCode = model.ProductCode;
newData.ProductHeaderId = model.ProductHeaderId;
newData.ProductName = model.ProductName;
newData.ProductSubCategoryHeaderId = model.ProductSubCategoryHeaderId;
newData.Rate = model.Rate;
newData.UnitId = model.UnitId;
newData.ImageUrl3 = model.ImageUrl3;
newData.ImageUrl2 = model.ImageUrl2;
newData.ImageUrl1 = model.ImageUrl1;
db.Product.Add(newData);
db.SaveChanges();
TempData["SuccessMsg"] = "Product Added Successfully";
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
TempData["FailedMsg"] = e.Message;
}
}
else
{
TempData["FailedMsg"] = "Failed";
}
ViewBag.SubCategoryList = db.ProductSubCategory.AsEnumerable().Select(s => new ProductSubCategory {
ProductCategoryHeaderId = s.ProductCategoryHeaderId, ProductSubCategoryHeaderId = s.ProductSubCategoryHeaderId, ProductSubCategoryName = s.ProductSubCategoryName
});
ViewBag.UnitList = db.FndFlexValueSet.Where(w => w.FlexValueSetShortName == "unit").FirstOrDefault().FndFlexValue.Select(s => new VmSelectList {
Id = s.FlexValueId, Name = s.FlexValue
});
ViewBag.BrandList = db.FndFlexValueSet.Where(w => w.FlexValueSetShortName == "brand").FirstOrDefault().FndFlexValue.Select(s => new VmSelectList {
Id = s.FlexValueId, Name = s.FlexValue
});
ViewBag.CategoryList = db.ProductCategory.Select(s => new VmSelectList {
Id = s.ProductCategoryHeaderId, Name = s.ProductCategoryName
});
return(View(model));
}
public bool AddminLogin(Admin_Login admin_Login)
{
_dbContext.Admin_Logins.Add(admin_Login);
return(_dbContext.SaveChanges() > 0);
}
public ActionResult Create(Project project)
{
context.Projects.Add(project);
context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
public void Add(Order order)
{
db.Orders.Add(order);
db.SaveChanges();
}
public bool Add(Student student)
{
_ProjectDbContext.Students.Add(student);
return(_ProjectDbContext.SaveChanges() > 0);
}
public void Commit()
{
_context.SaveChanges();
}
public int UpdateMonitor(string key = null, string idSchedule = null, string location = null, string coordinate = null, float speed = -1, int status = -1)
{
if (key == null || idSchedule == null || location == null || coordinate == null || speed < 0 || (status != 0 && status != 1))
{
return(0);
}
if (CheckKey(key))
{
try
{
ProjectDbContext dbContext = new ProjectDbContext();
int idSche = dbContext.Schedules.Where(x => x.Code == idSchedule).First().ID;
int idCar = dbContext.Schedules.Where(x => x.Code == idSchedule).First().IDCar;
int idStudent = dbContext.Schedules.Where(x => x.Code == idSchedule).First().IDStudent;
string numberCar = dbContext.Cars.SingleOrDefault(x => x.ID == idCar).NumberCar;
string studentName = dbContext.Students.SingleOrDefault(x => x.ID == idStudent).Name;
// update online
if (dbContext.CurrentStates.SingleOrDefault(x => x.carID == numberCar) == null)
{
CurrentState currentState = new CurrentState();
currentState.carID = numberCar;
currentState.state = status;
currentState.studentID = idStudent;
currentState.studentName = studentName;
currentState.location = location;
currentState.coordinate = coordinate;
currentState.currentTime = DateTime.Now;
dbContext.CurrentStates.Add(currentState);
dbContext.SaveChanges();
}
else
{
CurrentState currentState = dbContext.CurrentStates.SingleOrDefault(x => x.carID == numberCar);
currentState.state = status;
currentState.studentID = idStudent;
currentState.studentName = studentName;
currentState.location = location;
currentState.coordinate = coordinate;
currentState.currentTime = DateTime.Now;
dbContext.SaveChanges();
}
// update history
History history = new History();
history.carID = numberCar;
history.carName = numberCar;
history.studentID = idStudent;
history.studentName = studentName;
history.scheduleID = idSche;
history.exactTime = DateTime.Now;
history.location = location;
history.coordinate = coordinate;
history.state = status;
history.speed = speed;
history.day = DateTime.Now.Day;
history.month = DateTime.Now.Month;
history.year = DateTime.Now.Year;
dbContext.Historys.Add(history);
dbContext.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
return(0);
}
public bool Add(Customer customer)
{
_projectDbContext.Customers.Add(customer);
return(_projectDbContext.SaveChanges() > 0);
}
public bool Add(StudentModel student)
{
_dbContext.Students.Add(student);
return(_dbContext.SaveChanges() > 0);
}
public void Add(ConsultResult consultResult)
{
db.ConsultResults.Add(consultResult);
db.SaveChanges();
}
public bool Add(Purchase purchase)
{
_dbContext.Purchases.Add(purchase);
return(_dbContext.SaveChanges() > 0);
}
public bool Add(Sale sale)
{
_projectDbContext.Sales.Add(sale);
return(_projectDbContext.SaveChanges() > 0);
}
