public HttpResponseMessage UploadFile() { try { var httpRequest = HttpContext.Current.Request; var file = httpRequest.Files["File"]; BinaryReader br = new BinaryReader(file.InputStream); byte[] filedata = br.ReadBytes(file.ContentLength); string currentemail = httpRequest.Params["Email"]; string filedesc = httpRequest.Params["Filedesc"]; string typeoffile = httpRequest.Params["Filetype"]; OnboardEntities od = new OnboardEntities(); string upid = od.UserProfiles.First(s => s.email == currentemail).UPID; FileData fd = new FileData(); fd.FID = Convert.ToString(Guid.NewGuid()); fd.UPID = upid; fd.File = filedata; fd.FileName = file.FileName; fd.TypeOfFile = typeoffile; fd.FileType = file.ContentType; fd.FileDescription = filedesc; od.FileDatas.Add(fd); od.SaveChanges(); List <FileData> filesdata = od.FileDatas.Where(s => s.UPID == upid).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, filesdata)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
//Create Customer public JsonResult CreateCustomer(Customer customer) { try { db.Customers.Add(customer); db.SaveChanges(); } catch (Exception e) { Console.Write("Exception Occured /n {0}", e.Data); return(new JsonResult { Data = "Create Customer Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Customer created", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult EditCustomer(Customer customer) { var v = db.Customers.Where(a => a.Id == customer.Id).FirstOrDefault(); if (v != null) { v.CustomerName = customer.CustomerName; v.CustomerAddress = customer.CustomerName; } try { db.SaveChanges(); } catch (Exception e) { return(new JsonResult { Data = e, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Updated", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
// DELETE Product public JsonResult DeleteProduct(int id) { try { var product = db.Products.Where(p => p.id == id).SingleOrDefault(); if (product != null) { db.Products.Remove(product); db.SaveChanges(); } } catch (Exception e) { Console.Write(e.Data + "Exception Occured"); return(new JsonResult { Data = "Deletion Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
// DELETE Sale public JsonResult DeleteSale(int id) { try { var sale = db.Sales.Where(s => s.id == id).SingleOrDefault(); if (sale != null) { db.Sales.Remove(sale); db.SaveChanges(); } } catch (Exception e) { Console.Write("Exception Occured /n {0}", e.Data); return(new JsonResult { Data = "Deletion Falied", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public HttpResponseMessage DeleteData(string dataid, string empid, string table) { try { using (OnboardEntities db = new OnboardEntities()) { if (table == "TechnicalSkills") { db.TechnicalSkillDatas.Remove(db.TechnicalSkillDatas.Where(x => (x.TSDID == dataid && x.UPID == empid)).First()); } else if (table == "FunctionalSkills") { db.FunctionalSkillDatas.Remove(db.FunctionalSkillDatas.Where(x => (x.FSDID == dataid && x.UPID == empid)).First()); } else if (table == "Qualifications") { db.QualificationDatas.Remove(db.QualificationDatas.Where(x => (x.QDID == dataid && x.UPID == empid)).First()); } else if (table == "Trainings") { db.TainingDatas.Remove(db.TainingDatas.Where(x => (x.TDID == dataid && x.UPID == empid)).First()); } else if (table == "Certifications") { db.CertificationDatas.Remove(db.CertificationDatas.Where(x => (x.CDID == dataid && x.UPID == empid)).First()); } else if (table == "Memberships") { db.MembershipDatas.Remove(db.MembershipDatas.Where(x => (x.MDID == dataid && x.UPID == empid)).First()); } else if (table == "Employers") { db.EmployerDatas.Remove(db.EmployerDatas.Where(x => (x.EDID == dataid && x.UPID == empid)).First()); } else if (table == "Files") { db.FileDatas.Remove(db.FileDatas.Where(x => (x.FID == dataid && x.UPID == empid)).First()); } db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
public HttpResponseMessage SubmitData() { try { OnboardEntities db = new OnboardEntities(); var httpRequest = HttpContext.Current.Request; string email = httpRequest.Params["Email"]; UserOfferDetail ud = db.UserOfferDetails.First(x => x.emailID == email); ud.isEditable = false; ud.isSubmitted = true; db.SaveChanges(); OnboardingHelper helper = new OnboardingHelper(); string status = helper.SubmitUserData(email); return(Request.CreateResponse(HttpStatusCode.OK, status)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
public HttpResponseMessage CreateUserProfile(string email, string name) { try { OnboardingHelper helper = new OnboardingHelper(); OnboardEntities onboard = new OnboardEntities(); UserOfferDetail ud = new UserOfferDetail(); ud.emailID = email; ud.name = name; ud.createdDate = DateTime.Now.ToString(); ud.isSubmitted = false; ud.isEditable = true; onboard.UserOfferDetails.Add(ud); onboard.SaveChanges(); List <UserOfferDetail> profileData = helper.GetAllUsers(); return(Request.CreateResponse(HttpStatusCode.OK, profileData)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }