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));
}
}
public HttpResponseMessage GetFileName(string fileid)
{
try
{
OnboardEntities onboard = new OnboardEntities();
string filename = onboard.FileDatas.First(p => p.FID == fileid).FileName;
return(Request.CreateResponse(HttpStatusCode.OK, filename));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage GetFiles(string email)
{
try
{
OnboardEntities onboard = new OnboardEntities();
string upid = onboard.UserProfiles.First(s => s.email == email).UPID;
List <FileData> filesdata = onboard.FileDatas.Where(s => s.UPID == upid).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, filesdata));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
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 DownloadFile(string data, string empid)
{
try
{
OnboardEntities onboard = new OnboardEntities();
FileData file = onboard.FileDatas.ToList().Find(p => (p.UPID == empid && p.FID == data));
string name = file.FileName;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new ByteArrayContent(file.File);
response.Content.Headers.ContentLength = file.File.LongLength;
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentDisposition.FileName = file.FileName;
return(response);
}
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));
}
}
