public ActionResult Create([Bind(Include = "id,name,surname,age,jobtitle,home_city,experience,photo")] employee employee, HttpPostedFileBase photo)
{
if (ModelState.IsValid)
{
Random random = new Random();
var randomName = random.Next(1, 1000000000);
if (photo.ContentType != "image/png" && photo.ContentType != "image/jpg" && photo.ContentType != "image/jpeg")
{
Session["Error"] = "You can upload png, jpg and jpeg files";
return(RedirectToAction("create", "employees"));
}
if (photo.ContentLength > 1048576)
{
Session["Error"] = "Your file can be max 1 MB";
return(RedirectToAction("create", "employees"));
}
var nameMainImage = Path.GetFileName(photo.FileName);
var srcMain = Path.Combine(Server.MapPath("~/Uploads/"), randomName + nameMainImage);
photo.SaveAs(srcMain);
employee.photo = "/Uploads/" + randomName + nameMainImage;
db.employee.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public JsonResult Add(ProductSold prod)
{
using (db)
{
db.ProductSolds.Add(prod);
db.SaveChanges();
return(Json(prod, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create([Bind(Include = "Name,Email,UserID")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create(ListGen listgen)
{
if (ModelState.IsValid)
{
db.ListGens.Add(listgen);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ListGenId = new SelectList(db.ListGens, "ListGenId", "Name");
return(View(listgen));
}
public ActionResult Create([Bind(Include = "Description,DueDate,CompletionStatus,TaskID,Owner")] Task task)
{
if (ModelState.IsValid)
{
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Owner = new SelectList(db.Users, "UserID", "Name", task.Owner);
return(View(task));
}
public ActionResult Create(Task task, int?parentListId)
{
if (ModelState.IsValid)
{
task.ListGenId = parentListId;
// list.Tasks.Add(task);
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Edit", "StoreListGen", new { listId = task.ListGenId }));
}
ViewBag.ListGenId = new SelectList(db.Tasks, "TaskId");
return(View(task));
}
public void newTask(string doTo, DateTime dateTime)
{
task_bar task = new task_bar();
task.toDo = doTo;
task.dateTime = dateTime;
task.done = false;
task.expired = false;
entities.task_bar.Add(task);
entities.SaveChanges();
// var task = entities.task_bar.Where(x => x.toDo == "Einkaufen).FirstOrDefault();"
}
public HttpResponseMessage put(int id, TASK task)
{
try
{
using (TaskEntities entities = new TaskEntities())
{
var entity = entities.TASK.FirstOrDefault(e => e.TaskId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task doesnt exist"));
}
else
{
entity.AssignDate = task.AssignDate;
entity.DueDate = task.DueDate;
entity.ProjectId = task.ProjectId;
entity.TaskName = task.TaskName;
entity.Status = task.Status;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void UpdateEmployee(tblEmployeeDetail objTblEmp, Employee objEmployee)
{
objTblEmp.FirstName = objEmployee.FirstName;
objTblEmp.LastName = objEmployee.LastName;
objTblEmp.Email = objEmployee.Email;
objTblEmp.Mobile = objEmployee.Mobile;
objTblEmp.Phone = objEmployee.Phone;
tblAddress objAddress = ConvertAddress(objEmployee.CommunicationAddress);
tblAddress objTblAddress = entities.tblAddresses.Find(objAddress.AddressID);
objTblAddress.Address1 = objAddress.Address1;
objTblAddress.Address2 = objAddress.Address2;
objTblAddress.Address3 = objAddress.Address3;
objTblAddress.StateID = objAddress.StateID;
objTblAddress.DistrictID = objAddress.DistrictID;
objTblAddress.CityID = objAddress.CityID;
objTblAddress.Pincode = objAddress.Pincode;
objTblEmp.CommunicationAddressID = objAddress.AddressID;
tblAddress objAddress1 = ConvertAddress(objEmployee.PermanentAddress);
tblAddress objTblAddress1 = entities.tblAddresses.Find(objAddress1.AddressID);
objTblAddress1.Address1 = objAddress1.Address1;
objTblAddress1.Address2 = objAddress1.Address2;
objTblAddress1.Address3 = objAddress1.Address3;
objTblAddress1.StateID = objAddress1.StateID;
objTblAddress1.DistrictID = objAddress1.DistrictID;
objTblAddress1.CityID = objAddress1.CityID;
objTblAddress1.Pincode = objAddress1.Pincode;
objTblEmp.PermanentAddressID = objTblAddress1.AddressID;
//objTblEmp.tblAddress1 = ConvertAddress(objEmployee.PermanentAddress);
entities.SaveChanges();
}
public ActionResult List(TblAttendance am, string Date, int[] StudentId)
{
for (int i = 0; i < StudentId.Length; i++)
{
am.S_Id = StudentId[i];
db.TblAttendances.Add(am);
db.SaveChanges();
}
return(Content("Done"));
}
public HttpResponseMessage post([FromBody] TASK task)
{
try
{
using (TaskEntities entities = new TaskEntities())
{
entities.TASK.Add(task);
entities.SaveChanges();
HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.Created, task);
message.Headers.Location = new Uri(Request.RequestUri + task.TaskId.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public JsonResult updateSchedule(Guid uid, string cron, int enable, string paras)
{
JsonResult result = new JsonResult();
try
{
TaskEntities db = new TaskEntities();
var old = db.Schedule_t.FirstOrDefault(p => p.Uid == uid);
old.Paras = paras;
old.Enable = enable;
old.Cron = cron;
db.SaveChanges();
result.Data = new { status = 1, msg = "成功修改" };
}
catch (Exception ex)
{
result.Data = new { status = 0, msg = ex.ToString() };
}
return(result);
}
public HttpResponseMessage delete(int id)
{
try
{
using (TaskEntities entities = new TaskEntities())
{
var entity = entities.TASK.FirstOrDefault(e => e.TaskId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task doesnt exist"));
}
else
{
entities.TASK.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void create(Task task)
{
db.Tasks.Add(task);
db.SaveChanges();
}
public int Add(T t)
{
DbContext.Set <T>().Add(t);
return(DbContext.SaveChanges());
}
public void Add(Tbl_Entity entity)
{
_DbSet.Add(entity);
_DBEntity.SaveChanges();
}
public void SaveChanges()
{
DBEntity.SaveChanges();
}