public int Update(tblResumeData resumeData)
{
try
{
using (var dbContext = new PMSEntities())
{
dbContext.tblResumeDatas.Attach(resumeData);
dbContext.Entry(resumeData).State = EntityState.Modified;
foreach (var obj in resumeData.tblEducations)
{
if (obj.Id != 0)
{
dbContext.tblEducations.Attach(obj);
dbContext.Entry(obj).State = EntityState.Modified;
}
else
{
obj.ResumeId = resumeData.ResumeId;
obj.EducationId = Guid.NewGuid();
dbContext.tblEducations.Add(obj);
}
}
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public ActionResult Edit(Purchase purchase)
{
if (ModelState.IsValid)
{
try
{
db.Purchases.Attach(purchase);
db.Entry(purchase).Property(r => r.IsPaid).IsModified = true;
db.Entry(purchase).Property(r => r.Description).IsModified = true;
//db.Entry(purchase).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
ViewBag.Supplier_ID = new SelectList(db.Suppliers, "ID", "Supplier_Name", purchase.Supplier_ID);
return(View(purchase));
}
public ActionResult EditRoleMemberWS(WS_User_Roles model, List <string> chk1)
{
WS_User_Roles wsp = db.WS_User_Roles.Find(model.ID);
wsp.Role_Admin = model.Role_Admin;
wsp.Role_Manager = model.Role_Manager;
wsp.Role_Member = model.Role_Member;
db.Entry(wsp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("AddMemberWS", new { id = wsp.WorkSpace_ID }));
}
public ActionResult Edit([Bind(Include = "DrId,DrName,DrPassword,Specialzaition,DrEmail,DrContactNumber,DrExperience,DrGender,IsActive,Cretedby,Modifiedby,Creteddate,Modifieddate")] DoctorManage doctorManage)
{
if (ModelState.IsValid)
{
try
{
var ModifiedName = Convert.ToString(Session["AdminName"]);
doctorManage.Modifiedby = ModifiedName;
if (Session["DrId"] == null)
{
doctorManage.IsActive = false;
}
else if (Session["DrId"] != null)
{
doctorManage.IsActive = true;
}
doctorManage.Modifieddate = DateTime.Now;
db.Entry(doctorManage).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Doctor Details Updated!!";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["err"] = ex.Message;
}
}
return(View(doctorManage));
}
public IHttpActionResult PutExaminationType(Guid id, ExaminationType examinationType)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != examinationType.ExaminationTypeId)
{
return(BadRequest());
}
db.Entry(examinationType).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ExaminationTypeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Edit([Bind(Include = "StaffId,StaffName,StaffPassword,StaffEmail,StaffContactNumber,StaffDesignation,StaffExperience,IsActive,Cretedby,Modifiedby,Creteddate,Modifieddate")] StaffManage staffManage)
{
if (ModelState.IsValid)
{
try
{
var ModifiedName = Convert.ToString(Session["AdminName"]);
staffManage.Modifiedby = ModifiedName;
staffManage.Modifieddate = DateTime.Now;
if (Session["SId"] == null)
{
staffManage.IsActive = false;
}
else if (Session["SId"] != null)
{
staffManage.IsActive = true;
}
db.Entry(staffManage).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Staff Details Updated!!";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["err"] = ex.Message;
}
}
return(View(staffManage));
}
public ActionResult Edit([Bind(Include = "Pid,Pname,Address1,Address2,Gender,DOB,PContactNumber,PEmail,Cretedby,Modifiedby,Creteddate,Modifieddate,RefCityid")] PatientManage patientManage)
{
if (ModelState.IsValid)
{
try
{
var ModifiedName = Convert.ToString(Session["AdminName"]);
patientManage.Modifiedby = ModifiedName;
patientManage.Modifieddate = DateTime.Now;
db.Entry(patientManage).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Patient Details Updated!!";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["err"] = ex.Message;
}
}
ViewBag.CountryId = new SelectList(db.CountryMasters.ToList(), "CountryId", "CountryName");
ViewBag.StateId = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "", Value = "Select State"
}
};
ViewBag.RefCityid = new SelectList(db.CityMasters, "CityId", "CityName", patientManage.RefCityid);
return(View(patientManage));
}
public async Task <ActionResult> Edit(newProjectModels model)
{
try
{
if (ModelState.IsValid)
{
db.Entry(model).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
if (ex is DbEntityValidationException)
{
foreach (var validationErrors in ((DbEntityValidationException)ex).EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
//return InternalServerError();
}
}
ViewBag.ApplicationsId = new SelectList(db.Applications, "Id", "Name", model.ApplicationsId);
ViewBag.ArchitectId = new SelectList(db.Architects, "Id", "FullName", model.ArchitectId);
ViewBag.BusinessPartnerId = new SelectList(db.BusinessPartners, "Id", "FullName", model.BusinessPartnerId);
ViewBag.FixingTypeId = new SelectList(db.FixingTypes, "Id", "Name", model.FixingTypeId);
ViewBag.OwnerId = new SelectList(db.Owners, "Id", "FullName", model.OwnerId);
ViewBag.ProjectTypeId = new SelectList(db.ProjectTypes, "Id", "Name", model.ProjectTypeId);
return(View(model));
}
public void Update(Vehicle_Parking obj)
{
using (PMSEntities db = new PMSEntities())
{
db.Vehicle_Parking.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public ActionResult Edit(Drug_Generic_name drug_generic_name)
{
if (ModelState.IsValid)
{
db.Entry(drug_generic_name).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(drug_generic_name));
}
/// <summary>
/// Thay đổi role của một user
/// </summary>
/// <param name="model">Participate model</param>
public void editRoleUser(Participate model)
{
Participate user = findMemberInGroup(model.Id);
user.IsAdmin = model.IsAdmin;
user.IsManager = model.IsManager;
user.Updated_At = DateTime.Now;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public ActionResult Edit(Medicine_Information medicine_information)
{
if (ModelState.IsValid)
{
db.Medicine_Information.Attach(medicine_information);
db.Entry(medicine_information).Property(r => r.Medicine_Name).IsModified = true;
db.Entry(medicine_information).Property(r => r.Category).IsModified = true;
db.Entry(medicine_information).Property(r => r.Manufacturer_ID).IsModified = true;
// db.Entry(medicine_information).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(medicine_information));
}
//ViewBag.Generic_ID = new SelectList(db.Drug_Generic_name, "ID", "Genric_Name", medicine_information.Generic_ID);
// ViewBag.Manufacturer_ID = new SelectList(db.Manufacturers, "ID", "Manufacturer_Name", medicine_information.Manufacturer_ID);
}
public ActionResult Edit(Supplier supplier)
{
if (ModelState.IsValid)
{
db.Entry(supplier).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Edit(Sale sale)
{
if (ModelState.IsValid)
{
db.Entry(sale).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Bill_Invoice = new SelectList(db.Bill_Information, "Invoice_No", "Discount", sale.Bill_Invoice);
ViewBag.Medicine_ID = new SelectList(db.Medicine_Information, "ID", "Medicine_Name", sale.Medicine_ID);
return(View(sale));
}
public ActionResult Edit(Batch batch)
{
if (ModelState.IsValid)
{
db.Batches.Attach(batch);
db.Entry(batch).Property(r => r.Sell_Price).IsModified = true;
//db.Entry(batch).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Medicine_ID = new SelectList(db.Medicine_Information, "ID", "Medicine_Name", batch.Medicine_ID);
ViewBag.Purchase_ID = new SelectList(db.Purchases, "Purchase_ID", "Discount", batch.Purchase_ID);
return(View(batch));
}
public ActionResult AEdit([Bind(Include = "RefPid,RefDid,AppointmentStartDate,AppointmentEndDate,Purpose,Status,DocumentUpload,Cretedby,Modifiedby,Creteddate,Modifieddate,Aid")] AppointmentManage appointmentManage)
{
if (ModelState.IsValid)
{
try
{
var ModifiedName = Convert.ToString(Session["AdminName"]);
appointmentManage.Modifiedby = ModifiedName;
appointmentManage.Modifieddate = DateTime.Now;
db.Entry(appointmentManage).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Appointment Updated!!";
return(RedirectToAction("AIndex"));
}
catch (Exception ex)
{
TempData["err"] = ex.Message;
}
}
ViewBag.RefDid = new SelectList(db.DoctorManages, "DrId", "DrName", appointmentManage.RefDid);
ViewBag.RefPid = new SelectList(db.PatientManages, "Pid", "Pname", appointmentManage.RefPid);
return(View(appointmentManage));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,VisitedBy,VisitedOn,ActionPlanReportUrl,NewProjectId,ProjectStatusId,ProjectHealthId")] VisitReport visitReport)
{
if (ModelState.IsValid)
{
db.Entry(visitReport).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.NewProjectId = new SelectList(db.NewProjects, "Id", "ProjectName", visitReport.NewProjectId);
ViewBag.ProjectHealthId = new SelectList(db.ProjectHealths, "Id", "Name", visitReport.ProjectHealthId);
ViewBag.ProjectStatusId = new SelectList(db.ProjectStatus, "Id", "Name", visitReport.ProjectStatusId);
return(View(visitReport));
}
public JsonResult SaveAndUpdateProduct(int PID, string Name, string Description, float Price)
{
var result = new jsonMessage();
try
{
//define the model
Mst_Product _Mst_Product = new Mst_Product();
_Mst_Product.PID = PID;
_Mst_Product.Name = Name;
_Mst_Product.Description = Description;
_Mst_Product.Price = Price;
//for insert recored..
if (_Mst_Product.PID == 0)
{
context.Mst_Product.Add(_Mst_Product);
result.Message = "your product has been saved success..";
result.Status = true;
}
else //for update recored..
{
context.Entry(_Mst_Product).State = EntityState.Modified;
result.Message = "your product has been updated successfully..";
result.Status = true;
}
context.SaveChanges();
}
catch (Exception ex)
{
ErrorLogers.ErrorLog(ex);
result.Message = "We are unable to process your request at this time. Please try again later.";
result.Status = false;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public int Update(tblVendorData data)
{
try
{
using (var dbContext = new PMSEntities())
{
dbContext.tblVendorDatas.Attach(data);
dbContext.Entry(data).State = EntityState.Modified;
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public int UpdateOutward(tblOutwardWO outWardData)
{
try
{
using (var dbContext = new PMSEntities())
{
dbContext.tblOutwardWOes.Attach(outWardData);
dbContext.Entry(outWardData).State = EntityState.Modified;
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public async Task <ActionResult> Edit([Bind(Include = "Id,ProjectName,City,Street,CommencedOn,ConcludedOn,ArchitectId,BusinessPartnerId,PlanUrl,SectionsUrl,ElevationsUrl,TDImageUrl,AreaPanelCalculationUrl,ConceptsDrawingUrl,OptimizationUrl,ShopDrawingUrl,AnalysisUrl,BOQUrl,InteriorUrl,OwnerId,ProjectTypeId,FixingTypeId,ApplicationsId,TDRenderImageUrl")] NewProject newProject)
{
if (ModelState.IsValid)
{
db.Entry(newProject).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.ApplicationsId = new SelectList(db.Applications, "Id", "Name", newProject.ApplicationsId);
ViewBag.ArchitectId = new SelectList(db.Architects, "Id", "FullName", newProject.ArchitectId);
ViewBag.BusinessPartnerId = new SelectList(db.BusinessPartners, "Id", "FullName", newProject.BusinessPartnerId);
ViewBag.FixingTypeId = new SelectList(db.FixingTypes, "Id", "Name", newProject.FixingTypeId);
ViewBag.OwnerId = new SelectList(db.Owners, "Id", "FullName", newProject.OwnerId);
ViewBag.ProjectTypeId = new SelectList(db.ProjectTypes, "Id", "Name", newProject.ProjectTypeId);
return(View(newProject));
}
public int Update(tblCorrespondence correspondenceData)
{
try
{
using (var dbContext = new PMSEntities())
{
dbContext.tblCorrespondences.Attach(correspondenceData);
dbContext.Entry(correspondenceData).State = EntityState.Modified;
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
static void PerformScheduledTasks(string key, Object value, CacheItemRemovedReason reason)
{
try
{
PMSEntities context = new PMSEntities();
SerialPort Stream = new SerialPort("COM15", 9600);
Stream.Close();
Stream.Open();
string parkID = Stream.ReadLine();
string parkIDNew = parkID.Remove(parkID.Length - 1);
System.Threading.Thread.Sleep(1000);
string value1 = Stream.ReadLine();
string valueNew = value1.Remove(value1.Length - 1);
parking objParking = context.parkings.Where(o => o.parking_id == parkIDNew).FirstOrDefault();
if (valueNew == "in")
{
objParking.parking_available_slots = objParking.parking_available_slots - 1;
}
else
{
objParking.parking_available_slots = objParking.parking_available_slots + 1;
}
context.Entry(objParking).State = EntityState.Modified;
context.SaveChanges();
//GetCount();
Stream.Close();
ScheduleTaskTrigger();
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete(T model)
{
dataContext.Entry(model).State = EntityState.Modified;
dataContext.SaveChanges();
}
public HttpResponseMessage UpdateProduct(int id)
{
Product product = new Product();
HttpResponseMessage result = null;
var httpRequest = HttpContext.Current.Request;
product.PID = id;
product.PName = httpRequest["PName"];
product.Discount = Convert.ToInt32(httpRequest["Discount"]);
product.Price = Convert.ToInt32(httpRequest["Price"]);
product.Quantity = Convert.ToInt32(httpRequest["Quantity"]);
if (httpRequest["IsStock"] == "true")
{
product.IsStock = true;
}
else
{
product.IsStock = false;
}
if (httpRequest.Files.Count > 0)
{
//var docfiles = new List<string>();
foreach (string file in httpRequest.Files)
{
var allowedExtensions = new[] {
".jpg", ".png", ".jpg", "jpeg"
};
var postedFile = httpRequest.Files[file];
var fileName = Path.GetFileName(postedFile.FileName); //getting only file name(ex-ganesh.jpg)
var ext = Path.GetExtension(postedFile.FileName); //getting the extension(ex-.jpg)
if (allowedExtensions.Contains(ext.ToLower())) //check what type of extension
{
Stream stream = postedFile.InputStream;
BinaryReader binaryReader = new BinaryReader(stream);
Byte[] bytes = binaryReader.ReadBytes((int)stream.Length);
product.ImageName = fileName;
product.ImageCode = bytes;
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
else
{
throw;
}
}
}
}
result = Request.CreateResponse(HttpStatusCode.NoContent);
}
else
{
result = Request.CreateResponse(HttpStatusCode.BadRequest);
}
return(result);
}
public void Edit(HMS_Control control)
{
dbContext.Entry(control).State = EntityState.Modified;
dbContext.SaveChanges();
}
