public ActionResult ViewPost(int id)
{
Post post = new Post();
var userID = Convert.ToInt32(Session["id"]);
bool exist;
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
post = db.Posts.Where(x => x.PostID == id).FirstOrDefault();
exist = db.Likes.Any(x => x.PostId == id && x.UserId == userID);
if (exist == false)
{
ViewBag.Like = false;
}
else
{
ViewBag.Like = true;
}
post.Likes = db.Likes.Count(x => x.PostId == id);
db.Entry(post).Property("Likes").IsModified = true;
db.SaveChanges();
post.Comments = db.Comments.Count(x => x.PostId == id);
db.Entry(post).Property("Comments").IsModified = true;
db.SaveChanges();
}
return(View(post));
}
public void Remove(Tbl_Entity entity)
{
if (_DBEntity.Entry(entity).State == EntityState.Detached)
{
_dbSet.Attach(entity);
}
_dbSet.Remove(entity);
}
public ActionResult _Gallery()
{
//using (MyDatabaseEntities db = new MyDatabaseEntities())
//{
// Session["id"] = db.Users.Where(u => u.EmailID == User.Identity.Name).FirstOrDefault().UserID;
// var id = Convert.ToInt32(Session["id"]);
// UserData usrD = new UserData
// {
// ProfileImage = db.UserDatas.Where(x => x.Id == id).FirstOrDefault().ProfileImage
// };
// ViewBag.Pic = usrD;
//}
try {
int id = Convert.ToInt32(Session["id"]);
string image = Session["img"].ToString();
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
var user = db.UserDatas.Where(x => x.Id == id).FirstOrDefault();
user.ProfileImage = image;
foreach (var item in db.Posts)
{
if (item.UserID == id)
{
item.UserPicture = image;
db.Entry(item).Property("UserPicture").IsModified = true;
//db.SaveChanges();
}
}
db.Entry(user).Property("ProfileImage").IsModified = true;
db.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult addData(Service service)
{
var result = new JsonResult();
if (ModelState.IsValid)
{
service.CreatedByUserId = 1;
service.CreatedByUserName = "******";
service.CreatedByUSerDate = DateTime.Now;
_context.Entry(service).State = EntityState.Added;
_context.SaveChanges();
}
return(Json(result));
}
public IHttpActionResult PutTransaction(int id, Transaction transaction)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != transaction.Id)
{
return(BadRequest());
}
db.Entry(transaction).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TransactionExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult saveuser(int id, string propertyName, string value)
{
var status = false;
var message = "";
//Update data to database
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var user = dc.SiteUsers.Find(id);
object updateValue = value;
bool isValid = true;
if (propertyName == "RoleID")
{
int newRoleID = 0;
if (int.TryParse(value, out newRoleID))
{
updateValue = newRoleID;
//Update value field
value = dc.UserRoles.Where(a => a.ID == newRoleID).First().RoleName;
}
else
{
isValid = false;
}
}
else if (propertyName == "DOB")
{
DateTime dob;
if (DateTime.TryParseExact(value, "dd-MM-yyyy", new CultureInfo("en-US"), DateTimeStyles.None, out dob))
{
updateValue = dob;
}
else
{
isValid = false;
}
}
if (user != null && isValid)
{
dc.Entry(user).Property(propertyName).CurrentValue = updateValue;
dc.SaveChanges();
status = true;
}
else
{
message = "Error!";
}
}
var response = new { value = value, status = status, message = message };
JObject o = JObject.FromObject(response);
return(Content(o.ToString()));
}
public ActionResult Edit(User_Folder user_folder)
{
if (ModelState.IsValid)
{
db.Entry(user_folder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user_folder));
}
public ActionResult Edit(Thread thread)
{
if (ModelState.IsValid)
{
db.Entry(thread).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thread));
}
public ActionResult Edit([Bind(Include = "CustomerId,Name,Address,Phone,OrderDate")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "Id,name,address,city,email,phonne")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Edit([Bind(Include = "OrderID,OrderNo,OrderDate,Description")] OrderMaster orderMaster)
{
if (ModelState.IsValid)
{
db.Entry(orderMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(orderMaster));
}
public ActionResult Edit([Bind(Include = "Id,Название_маршрута,Примечание")] Маршрут маршрут)
{
if (ModelState.IsValid)
{
db.Entry(маршрут).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(маршрут));
}
public ActionResult Edit([Bind(Include = "ProductID,CategoryID,ProductName")] Product product)
{
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Edit(ProductGalary productgalary)
{
if (ModelState.IsValid)
{
db.Entry(productgalary).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(productgalary));
}
public ActionResult Edit([Bind(Include = "DoctorID,FirstName,LastName,Job,Directory,Date")] Doctor doctor)
{
if (ModelState.IsValid)
{
db.Entry(doctor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(doctor));
}
public ActionResult Edit(message Message)
{
if (ModelState.IsValid)
{
db.Entry(Message).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(Message));
}
public ActionResult Edit([Bind(Include = "LocationID,Title,Lat,Long,Address,Phone,ImagePath,Detail,Price,Bed,Wardrobe,Conditioner,Desk,Toilet,Refrigrator,Wifi")] Location location)
{
if (ModelState.IsValid)
{
db.Entry(location).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(location));
}
public ActionResult Edit([Bind(Include = "CategoryID,CategoryName")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit([Bind(Include = "name,email,mobilePhone,birthday,contactTime,remark")] Account account)
{
if (ModelState.IsValid)
{
db.Entry(account).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(account));
}
public ActionResult editData(Module module)
{
if (ModelState.IsValid)
{
_context.Entry(module).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "PacjentID,FirstName,LastName,Choroba,Date,Telefon,DoctorID")] Pacjent pacjent)
{
if (ModelState.IsValid)
{
db.Entry(pacjent).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DoctorID = new SelectList(db.Doctors, "DoctorID", "FirstName", pacjent.DoctorID);
return(View(pacjent));
}
public ActionResult addData(Component comp)
{
var result = new JsonResult();
if (ModelState.IsValid)
{
{
_context.Entry(comp).State = EntityState.Added;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.Message = ModelState.GetModelStateErrors();
result.IsSuccess = false;
result.Message = "validation failed";
}
return(Json(result));
}
public ActionResult Edit([Bind(Include = "Id,Название_типа")] Тип_ТС тип_ТС)
{
if (ModelState.IsValid)
{
db.Entry(тип_ТС).State = EntityState.Modified;
тип_ТС.Название_типа = тип_ТС.Название_типа.Trim();
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(тип_ТС));
}
public async Task <ActionResult> Edit([Bind(Include = "id,name,email,address")] User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Edit([Bind(Include = "OrderId,ProductName,Quantity,Price,Amount,CustomerId")] Order order)
{
if (ModelState.IsValid)
{
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name", order.CustomerId);
return(View(order));
}
public void UpdateStudent(int id, string name, DateTime brithday, int class_id)
{
var db = new MyDatabaseEntities();
var student = db.Students.Find(id);
student.Name = name;
student.Brithay = brithday;
student.Class_id = class_id;
db.Entry(student).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "OrderDetailsID,OrderID,ProductID,Rate,Quantity")] OrderDetail orderDetail)
{
if (ModelState.IsValid)
{
db.Entry(orderDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderID = new SelectList(db.OrderMasters, "OrderID", "OrderNo", orderDetail.OrderID);
return(View(orderDetail));
}
public ActionResult editData(ControllerDetail postEdit)
{
if (ModelState.IsValid)
{
_context.Entry(postEdit).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Название_задачи,Группа_задачID,Примечание")] Задача задача)
{
if (ModelState.IsValid)
{
db.Entry(задача).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Группа_задачID = new SelectList(db.Группы_задач, "Id", "Название_группы", задача.Группа_задачID);
return(View(задача));
}
public ActionResult editData(Developer developer)
{
var result = new JsonResult();
if (ModelState.IsValid)
{
_context.Entry(developer).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(Json(result));
}
