//Adding likes and dislikes
public JsonResult AddLike(int id, bool status)
{
if (id != 0)
{
likes_detail likeDetails = new likes_detail
{
BlogId = id,
IpAddress = Request.UserHostAddress,
LikeStatus = status,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
var ifExists = db.like_details.Where(i => i.BlogId == id && i.IpAddress == Request.UserHostAddress).SingleOrDefault();
if (ifExists != null)
{
ifExists.LikeStatus = status;
db.Entry(ifExists).State = EntityState.Modified;
db.SaveChanges();
}
else
{
db.like_details.Add(likeDetails);
db.SaveChanges();
}
}
return(Json("hii"));
}
public bool UserSave(TUser user)
{
if (user.Id == default)
{
//执行添加
user.Id = Guid.NewGuid();
user.IsDelete = false;
user.CreateTime = DateTime.Now;
user.RoleId = Guid.Parse("136A214E-7523-42F2-9760-8EED42B31BA1");
db.TUser.Add(user);
}
else
{
//执行修改
var dbUserSys = db.TUser.Where(t => t.Id == user.Id).FirstOrDefault();
dbUserSys.Name = user.Name;
dbUserSys.NickName = user.NickName;
dbUserSys.Phone = user.Phone;
dbUserSys.Email = user.Email;
dbUserSys.PassWord = user.PassWord;
}
db.SaveChanges();
return(true);
}
public static bool Authenticate(string userName, string userPassword)
{
CreateAdmin(); // Comment out this line if you already have admin account
if (string.IsNullOrWhiteSpace(userName) || string.IsNullOrWhiteSpace(userPassword))
{
return(false);
}
var user = _db.Users.Where(x => x.UserName == userName.Trim().ToLower()).FirstOrDefault();
if (user == null)
{
return(false);
}
if (!user.IsActive)
{
return(false);
}
bool valid = VerifyPasswordHash(userPassword, user.PasswordSalt, user.PasswordHash);
if (valid)
{
user.LastLogin = DateTime.Now;
_db.Entry(user).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
CurrentUser = user; // Set current user
return(true);
}
return(false);
}
public void addAssignment(AssignmentViewModel newAssignment)
{
using (var context = new dbContext())
{
assignment model = new assignment
{
name = newAssignment.Name,
maxSubmisions = newAssignment.MaxSubmissions,
groupSize = newAssignment.GroupSize,
startDate = newAssignment.AssignmentStart,
endDate = newAssignment.AssignmentEnd,
courseID = newAssignment.CourseID
};
context.assignments.Add(model);
context.SaveChanges();
assignmentPart modelPart = new assignmentPart
{
descriptoin = newAssignment.Description,
solutionFile = newAssignment.SolutionFile,
assignmentID = model.ID
};
context.assignmentParts.Add(modelPart);
context.SaveChanges();
}
}
public IActionResult Register(Users user, IFormFile photo)
{
if (photo == null || photo.Length == 0)
{
user.Pic = "No Image";
}
else
{
var path = Path.Combine(Directory.GetCurrentDirectory(), "", photo.FileName);
var stream = new FileStream(path, FileMode.Create);
user.Pic = photo.FileName;
}
byte[] data = UTF8Encoding.UTF8.GetBytes(user.Password);
using (MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider())
{
byte[] keys = md5.ComputeHash(UTF8Encoding.UTF8.GetBytes("hash"));
using (TripleDESCryptoServiceProvider tripDes = new TripleDESCryptoServiceProvider()
{
Key = keys, Mode = CipherMode.ECB, Padding = PaddingMode.PKCS7
})
{
ICryptoTransform transform = tripDes.CreateEncryptor();
byte[] results = transform.TransformFinalBlock(data, 0, data.Length);
user.Password = Convert.ToBase64String(results, 0, results.Length);
}
}
user.Type = "user";
user.Status = "Enable";
_context.Users.Add(user);
_context.SaveChanges();
ViewBag.email = HttpContext.Session.GetString("email");
return(RedirectToAction("Home"));
}
public IHttpActionResult PutEndUser(string id, EndUser endUser)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != endUser.user_name)
{
return(BadRequest());
}
db.Entry(endUser).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EndUserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void deletedraftmail(int draft_mail_id)
{
var delete_obj = _context.draft_mail_table.SingleOrDefault(m => m.draft_mail_ID == draft_mail_id);
_context.draft_mail_table.Remove(delete_obj);
_context.SaveChanges();
}
public void ToggleUpdate(bool isChecked, string propertyName)
{
var user = CurrentLoggedUser.Instance.GetLoggedUser();
using (var ctx = new dbContext())
{
User usrSettings = ctx.Users.FirstOrDefault(x => x.Id == user.Id);
if (usrSettings.Settings == null)
{
Setting settings = new Setting();
Type type = settings.GetType();
PropertyInfo prop = type.GetProperty(propertyName);
prop.SetValue(settings, isChecked, null);
usrSettings.Settings = settings;
ctx.Entry(usrSettings.Settings).State = EntityState.Added;
ctx.SaveChanges();
}
else
{
Type type = usrSettings.Settings.GetType();
PropertyInfo prop = type.GetProperty(propertyName);
prop.SetValue(usrSettings.Settings, isChecked, null);
ctx.Entry(usrSettings.Settings).State = EntityState.Modified;
ctx.SaveChanges();
}
}
}
public HttpResponseMessage PutProduct(int id, Product product)
{
HttpResponseMessage res;
try
{
var entity = db.Products.FirstOrDefault(p => p.Id == product.Id);
if (entity != null)
{
entity.Name = product.Name;
db.SaveChanges();
res = Request.CreateResponse(HttpStatusCode.OK, entity);
}
else
{
res = Request.CreateResponse(HttpStatusCode.NotFound, "Product id= " + product.Id + " not found");
}
}
catch (Exception ex)
{
res = Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
//res.Headers.Add("Access-Control-Allow-Origin", "*");
return(res);
}
res.Headers.Add("Access-Control-Allow-Origin", "*");
return(res);
}
public void UpdateEveryMin(bool isUpdateEveryOn, string updateEveryMin)
{
var user = CurrentLoggedUser.Instance.GetLoggedUser();
using (var ctx = new dbContext())
{
User usrSettings = ctx.Users.FirstOrDefault(x => x.Id == user.Id);
if (usrSettings.Settings == null)
{
Setting settings = new Setting();
settings.isUpdateEveryOn = isUpdateEveryOn;
settings.UpdateEveryMin = Convert.ToInt32(updateEveryMin);
usrSettings.Settings = settings;
ctx.Entry(usrSettings.Settings).State = EntityState.Added;
ctx.SaveChanges();
}
else
{
usrSettings.Settings.isUpdateEveryOn = isUpdateEveryOn;
usrSettings.Settings.UpdateEveryMin = Convert.ToInt32(updateEveryMin);
ctx.Entry(usrSettings.Settings).State = EntityState.Modified;
ctx.SaveChanges();
}
}
}
public ActionResult Create([Bind("MenuID,CategoryID,Content,ContentType,CreatedBy,CreatedDate,IsDeleted,MenuDescription,MenuName,MenuPrice,StatusID,UpdatedBy,UpdatedDate")] Menu menu, ICollection <IFormFile> files)
{
if (ModelState.IsValid)
{
//var uploads = Path.Combine(_environment.WebRootPath, "uploads");
foreach (var file in files)
{
if (file.Length > 0)
{
using (var fileStream = file.OpenReadStream())
using (var ms = new MemoryStream())
{
fileStream.CopyTo(ms);
var fileBytes = ms.ToArray();
string s = Convert.ToBase64String(fileBytes);
menu.Content = fileBytes;
menu.ContentType = file.ContentType;
// act on the Base64 data
}
}
}
menu.CreatedBy = "Admin";
menu.CreatedDate = DateTime.Now;
_context.Add(menu);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
ViewData["CategoryID"] = new SelectList(_context.Category, "CategoryID", "CategoryName", menu.CategoryID);
ViewData["StatusID"] = new SelectList(_context.Status, "StatusID", "StatusName", menu.StatusID);
return(View(menu));
}
public ActionResult Create([Bind(Include = "ModelId,Name,IsEnabled")] SampleModels sampleModels, HttpPostedFileBase LargeImage)
{
if (ModelState.IsValid)
{
if (LargeImage != null)
{
//saving both small and large images and receiving back their urls.
SampleModelMethods sampleModelMethods = new SampleModelMethods();
sampleModels.LargeImageUrl = sampleModelMethods.SaveLargeImage(LargeImage);
//adding records to database..
db.models.Add(sampleModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Please Select an image for project.");
}
//db.models.Add(sampleModels);
//db.SaveChanges();
//return RedirectToAction("Index");
}
return(View(sampleModels));
}
public IActionResult UpdateVehicles(Vehicle vehicle, IFormFile photo)
{
Vehicle vehicles = _context.Vehicle.Find(vehicle.VehicleNo);
if (photo == null || photo.Length == 0)
{
vehicle.Pic = vehicles.Pic;
}
else
{
var path = Path.Combine(Directory.GetCurrentDirectory(), "", photo.FileName);
var stream = new FileStream(path, FileMode.Create);
vehicle.Pic = photo.FileName;
}
vehicle.VehicleAvailability = true;
_context.Vehicle.Attach(vehicles);
vehicles.VehicleType = vehicle.VehicleType;
vehicles.Amount = vehicle.Amount;
vehicles.VehicleAvailability = vehicle.VehicleAvailability;
vehicles.Class = vehicle.Class;
_context.SaveChanges();
return(RedirectToAction("ViewVehicle"));
}
/// <summary>
/// Добавление посещений
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IActionResult AddVisit(VisitViewModel model)
{
var date = model.Date;
var saved = HttpContext.Session.GetString("SessionStorageThemes");
var storage = new List <SessionStorageThemes>();
if (storage != null)
{
storage = JsonConvert.DeserializeObject <List <SessionStorageThemes> >(saved);
}
var themeVisits = new List <ThemeVisit>();
foreach (var savedTheme in storage)
{
var theme = _db.Theme.Include(x => x.ThemeGroup).Include(x => x.Subject).ThenInclude(x => x.Semester).Where(x => x.Id == savedTheme.ThemeId).FirstOrDefault();
theme.ThemeGroup.UsedHours = savedTheme.ThemeGroup.UsedHours;
var hoursPerVisit = savedTheme.Reserved;
var typeSubject = theme.Type;
var themeVisit = new ThemeVisit()
{
HoursPerVisit = hoursPerVisit, Theme = theme, TypeSubject = typeSubject
};
themeVisits.Add(themeVisit);
}
var visit = new GroupVisit()
{
Date = date,
ThemeVisits = themeVisits,
Subject = _db.Subject.Find(model.SubjectId),
Group = _db.Group.Find(model.GroupId),
Semester = _db.Subject.Include(x => x.Semester).Where(x => x.Id == model.SubjectId).FirstOrDefault().Semester,
Theme = themeVisits.FirstOrDefault().Theme
};
_db.GroupVisit.Add(visit);
foreach (var visitModify in model.Output.VisitsModify)
{
var studentVisit = new StudentVisit()
{
TypeVisit = visitModify.TypeVisit,
Student = _db.Student.Find(visitModify.StudentId),
GroupVisit = visit,
Subject = _db.Subject.Find(model.SubjectId),
Theme = visit.ThemeVisits.FirstOrDefault().Theme
};
_db.StudentVisit.Add(studentVisit);
visit.StudentVisits.Add(studentVisit);
visit.Theme.StudentVisits.Add(studentVisit);
}
_db.SaveChanges();
return(View("VisitAddedView"));
}
public void Create([Bind(Include = "ProductId,ProductName,Price,RenewPrice")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
}
}
public IActionResult Delete(int id)
{
var merchant = _context.Merchants.First(i => i.Id == id);
_context.Merchants.Remove(merchant);
_context.SaveChanges();
return(Ok(merchant));
}
public void ResetCountAndDateError(string mail)
{
var User = db.mst_user.SingleOrDefault(x => x.mail == mail);
User.cnt_login_error = 0;
User.date_login_error = null;
db.SaveChanges();
}
public object Insert(List <FileModel> files, function item, Function_Extend itemExtend)
{
Message msg = new Message {
Error = false
};
using (DbContextTransaction dbTran = _dbContext.Database.BeginTransaction())
{
try
{
if (getNotExistsFunctionWhenInsert(item.Function1))
{
item.CreatedBy = ((account)Session["informationOfAccount"]).Account1;
item.CreatedDate = DateTime.Now;
item.ModifiedBy = ((account)Session["informationOfAccount"]).Account1;
item.ModifiedDate = DateTime.Now;
if (item.functionCategories != null)
{
item.functionCategoriesTitle = _dbContext.functionCategories.First(x => x.functionCategories == item.functionCategories).functionCategoriesTitle;
}
_dbContext.functions.Add(item);
_dbContext.SaveChanges();
msg.Title = Function_Message_InsertSuccess;
var ChildFunction = _dbContext.childOfFunctions.ToList();
foreach (var itemChild in ChildFunction)
{
if (itemExtend.ArrayFunction != null)
{
if (itemExtend.ArrayFunction.Find(x => x == itemChild.ChildOfFunction1) == null)
{
itemChild.RemoveFunction += "#" + itemExtend.Function1 + "#";
_dbContext.Entry(itemChild).Property(x => x.ID).IsModified = false;
_dbContext.Entry(itemChild).Property(x => x.Title).IsModified = false;
_dbContext.Entry(itemChild).Property(x => x.Order).IsModified = false;
_dbContext.SaveChanges();
}
}
}
dbTran.Commit();
}
else
{
msg.Title = Function_Message_InsertErrror;
msg.Error = true;
dbTran.Rollback();
}
}
catch (Exception ex)
{
msg.Title = Function_Message_InsertErrror;
msg.Error = true;
msg.Data = ex.ToString();
dbTran.Rollback();
}
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Animal animal)
{
if (ModelState.IsValid)
{
db.Animais.Add(animal);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(animal));
}
public ActionResult Create([Bind(Include = "Id,PageUrl,PageTitle,Keywords,Descriptions,PageContent")] PagesData pagesData)
{
if (ModelState.IsValid)
{
db.pageDataList.Add(pagesData);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pagesData));
}
public ActionResult Save(Models.StudentViewModel model)
{
if (ModelState.IsValid)
{
if (model.Student.Id == 0)
{
//new
var stu = new Models.Student();
//Note: Map file and model together.
stu.Name = model.Student.Name;
stu.Surname = model.Student.Surname;
stu.Email = model.Student.Email;
stu.StudentNumber = model.Student.StudentNumber;
stu.MobileNumber = model.Student.MobileNumber;
stu.TelNumber = model.Student.TelNumber;
stu.IsActive = model.Student.IsActive;
if (model.File != null)
{
string ext = Path.GetExtension(model.File.FileName);
stu.FilePath = @"~/datafolder/images/" + model.Student.ImageName + ext;
if (!Directory.Exists(Server.MapPath("/datafolder/images/")))
{
Directory.CreateDirectory(Server.MapPath("/datafolder/images/"));
}
model.File.SaveAs(Server.MapPath(stu.FilePath.Remove(0, 1)));
Blob.StorageHandler.Upload(Server.MapPath(stu.FilePath.Remove(0, 1)), stu.FilePath);
}
_db.Students.Add(stu);
}
else
{
//edit
var studentindb = _db.Students.Single(s => s.Id == model.Student.Id);
//Note: Map file and model together.
studentindb.Name = model.Student.Name;
studentindb.Surname = model.Student.Surname;
studentindb.Email = model.Student.Email;
studentindb.StudentNumber = model.Student.StudentNumber;
studentindb.MobileNumber = model.Student.MobileNumber;
studentindb.TelNumber = model.Student.TelNumber;
studentindb.IsActive = model.Student.IsActive;
if (model.File != null)
{
string ext = Path.GetExtension(model.File.FileName);
studentindb.FilePath = @"~/datafolder/images/" + model.Student.ImageName + ext;
model.File.SaveAs(Server.MapPath(studentindb.FilePath));
Blob.StorageHandler.Upload(Server.MapPath(studentindb.FilePath), studentindb.FilePath);
}
}
_db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public IActionResult PostCustomer(RequestData <Customer> customer)
{
_context.Customer.Add(customer.data.attributes);
_context.SaveChanges();
return(Ok(new
{
message = "success retrieve data",
status = true,
data = customer
}));
}
//Adds a new user to the [Users] table
public Users AddNewUser(Users newUser)
{
if (db.Users.FirstOrDefault
(u => u.UserId == newUser.UserId) == null)
{
db.Users.Add(newUser);
db.SaveChanges();
return(newUser);
}
return(null);
}
public ActionResult Create([Bind("BillID,BillDate,CreatedBy,CreatedDate,IsDeleted,OrderID,TotalPrice,UpdatedBy,UpdatedDate")] Bill bill)
{
if (ModelState.IsValid)
{
_context.Add(bill);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
ViewData["OrderID"] = new SelectList(_context.Order, "OrderID", "OrderID", bill.OrderID);
return(View(bill));
}
public ActionResult Create([Bind(Include = "Id_ClienteExterno,CExt_Nombre,CExt_Direccion,CExt_Telefono,CExt_FechaCreacion,CExt_Estado")] ClienteExterno clienteExterno)
{
if (ModelState.IsValid)
{
db.ClienteExternoes.Add(clienteExterno);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(clienteExterno));
}
public IActionResult Insertar([FromBody] Servicio servicio)
{
if (ModelState.IsValid)
{
db.Servicio.Add(servicio);
db.SaveChanges();
return(Json(servicio));
}
return(BadRequest());
}
public void changeMailStatus(int mail_id)
{
MailTable mailTable = new MailTable()
{
mail_ID = mail_id, mail_status = "read"
};
_context.mail_table.Attach(mailTable);
_context.Entry(mailTable).Property(x => x.mail_status).IsModified = true;
_context.SaveChanges();
}
public IActionResult Insertar([FromBody] Cliente cliente)
{
if (ModelState.IsValid)
{
db.Cliente.Add(cliente);
db.SaveChanges();
return(Json(cliente));
}
return(BadRequest());
}
public ActionResult Create([Bind(Include = "StudentId,StudentName,Age")] Infor infor)
{
if (ModelState.IsValid)
{
db.Infors.Add(infor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(infor));
}
public ActionResult Create([Bind(Include = "id,aName,DOB,city")] Artist artist)
{
if (ModelState.IsValid)
{
db.Artists.Add(artist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(artist));
}