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));
}
}
