private void GetWorkHistory(FreelancerProfileVM fp) //Metod för att hämta erfarenheter på inskickad freelancerVM och lagra dessa i dennes workhistory-lista
{
try
{
var list = (from w in db.workhistory
join r in db.resume on w.resume_id equals r.resume_id
where w.resume_id == fp.Resume_id
select new { w.workhistory_id, w.resume_id, w.employer, w.position, w.description, w.date }).ToList();
foreach (var item in list)
{
workhistory wo = new workhistory();
wo.workhistory_id = item.workhistory_id;
wo.resume_id = item.resume_id;
wo.employer = item.employer;
wo.position = item.position;
wo.description = item.description;
wo.date = item.date;
fp.WorkHistoryList.Add(wo);
}
}
catch (SqlException ex)
{
//TODO: gör något med felmeddelandet
throw;
}
}
public async Task <IHttpActionResult> Putworkhistory(int id, workhistory workhistory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != workhistory.idWorkHistory)
{
return(BadRequest());
}
db.Entry(workhistory).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!workhistoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
workhistory workhistory = db.workhistory.Find(id);
db.workhistory.Remove(workhistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IHttpActionResult> Getworkhistory(int id)
{
workhistory workhistory = await db.workhistories.FindAsync(id);
if (workhistory == null)
{
return(NotFound());
}
return(Ok(workhistory));
}
public ActionResult Edit([Bind(Include = "workhistory_id,resume_id,employer,position,description,date")] workhistory workhistory)
{
if (ModelState.IsValid)
{
db.Entry(workhistory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.resume_id = new SelectList(db.resume, "resume_id", "driving_license", workhistory.resume_id);
return(View(workhistory));
}
public async Task <IHttpActionResult> Postworkhistory(workhistory workhistory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.workhistories.Add(workhistory);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = workhistory.idWorkHistory }, workhistory));
}
public async Task <IHttpActionResult> Deleteworkhistory(int id)
{
workhistory workhistory = await db.workhistories.FindAsync(id);
if (workhistory == null)
{
return(NotFound());
}
db.workhistories.Remove(workhistory);
await db.SaveChangesAsync();
return(Ok(workhistory));
}
// GET: workhistories/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
workhistory workhistory = db.workhistory.Find(id);
if (workhistory == null)
{
return(HttpNotFound());
}
return(View(workhistory));
}
// GET: workhistories/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
workhistory workhistory = db.workhistory.Find(id);
if (workhistory == null)
{
return(HttpNotFound());
}
ViewBag.resume_id = new SelectList(db.resume, "resume_id", "driving_license", workhistory.resume_id);
return(View(workhistory));
}
private void SaveNewWorkHistory(object sender, RoutedEventArgs e)
{
try
{
if (selectedWorkHistory != 0)
{
workhistory uWorkHistory = dbContext.workhistory.SingleOrDefault(k => k.ID == selectedWorkHistory);
if (uWorkHistory != null)
{
uWorkHistory.structureName = cstructureName.Text.Substring(0, cstructureName.Text.Length > 500 ? 500 : cstructureName.Text.Length);
uWorkHistory.positionName = positionName.Text.Substring(0, positionName.Text.Length > 500 ? 500 : positionName.Text.Length);
uWorkHistory.beginDate = DateTime.Parse(workBeginDate.Text);
uWorkHistory.endDate = !string.IsNullOrEmpty(workEndDate.Text) ? DateTime.Parse(workEndDate.Text) : (DateTime?)null;
}
}
else
{
workhistory wkh = new workhistory();
wkh.empID = selectedPersonID;
wkh.structureName = cstructureName.Text.Substring(0, cstructureName.Text.Length > 500 ? 500 : cstructureName.Text.Length);
wkh.positionName = positionName.Text.Substring(0, positionName.Text.Length > 500 ? 500 : positionName.Text.Length);
wkh.beginDate = DateTime.Parse(workBeginDate.Text);
wkh.endDate = !string.IsNullOrEmpty(workEndDate.Text)?DateTime.Parse(workEndDate.Text): (DateTime?)null;
dbContext.workhistory.Add(wkh);
}
dbContext.SaveChanges();
// txtStatus.Text = rOrganization.organizationName + " has being added!";
}
catch (DbUpdateException ex)
{
MessageBox.Show("Problem yarandı" + ex.ToString());
}
finally
{
FillEducationList(selectedPersonID);
MessageBox.Show("Melumatlar saxlanıldı");
}
}
protected void btGenerate_Click(object sender, EventArgs e)
{
DateTime dateFrom = DateTime.Parse(txtFrom.Text);
DateTime dateTo = DateTime.Parse(txtTo.Text);
workDBDataContext db = new workDBDataContext();
var queryWorker = from a in db.worker
select a.username;
List <string> al = queryWorker.ToList();
var queryWorkerOne = from a in db.workhistory
where a.worktime == dateFrom.AddDays(-1)
select a.worker;
int s = -1;//从al[s]的后一个开始排班，共al.Count个人
if (queryWorkerOne != null && queryWorkerOne.Count() == 1)
{
for (int i = 0; i < al.Count; i++)
{
if (al[i].ToString() == queryWorkerOne.First())
{
s = i;
break;
}
} //s=i
}
int p; //判断是更新还是插入，0插入，1更新
int kongi = 0; //轮空
while (true)
{
switch (ddlSchedule.SelectedValue)
{
case "0":
//按人员顺序排列
s = (s + 1) % al.Count; //对al[s]进行排班
break;
case "1":
//每人向前一天（7个人）
s = (s + 1) % al.Count;
if (dateFrom.DayOfWeek == DayOfWeek.Sunday)
{
s = (s + 1) % al.Count;
}
break;
case "2":
//每人向前二天（7个人）
s = (s + 1) % al.Count;
if (dateFrom.DayOfWeek == DayOfWeek.Monday)
{
s = (s + 2) % al.Count;
}
break;
case "3":
//每轮轮空一人
s = (s + 1) % al.Count;
if (s == kongi)
{
s = (s + 1) % al.Count;
kongi = (kongi + 1) % al.Count;
}
break;
case "4":
//周四、五同一人值班
if (dateFrom.DayOfWeek != DayOfWeek.Friday)
{
s = (s + 1) % al.Count;
}
break;
case "5":
//依次排列早晚班
s = (s + 2) % al.Count;
break;
}
var queryCurrent = from a in db.workhistory
where a.worktime == dateFrom
select a;
p = queryCurrent.Count();//0插入，1更新
if (p == 1)
{
queryCurrent.First().worker = al[s];
if (ddlSchedule.SelectedValue == "5")
{
queryCurrent.First().worker1 = al[(s + 1) % al.Count];
}
db.SubmitChanges();
}
if (p == 0)
{
workhistory workIns = new workhistory();
workIns.worktime = dateFrom;
workIns.worker = al[s];
if (ddlSchedule.SelectedValue == "5")
{
workIns.worker1 = al[(s + 1) % al.Count];
}
workIns.workstatus = "0";
db.workhistory.InsertOnSubmit(workIns);
db.SubmitChanges();
}
if (dateFrom == dateTo)
{
break;
}
dateFrom = dateFrom.AddDays(1);
}
Response.Redirect("Default.aspx");
}
public async Task <bool> MyPortal()
{
string Email = string.Empty;
string FullName = string.Empty;
bool isvalid = false;
try
{
WebApiApplication._log.LogInfoFormat("MyPortal");
var context = HttpContext.Current.Request.Files;
var root = HttpContext.Current.Server.MapPath("~/App_Data/Temp/FileUploads");
Directory.CreateDirectory(root);
var provider = new MultipartFormDataStreamProvider(root);
var result = await Request.Content.ReadAsMultipartAsync(provider);
WebApiApplication._log.LogDebugFormat("MyPortal: {0}", result.FormData["postresumedata"]);
WebApiApplication._log.LogInfoFormat("MyPortal after debug print");
if (result.FormData["postresumedata"] != null)
{
var modelStr = result.FormData["postresumedata"];
JavaScriptSerializer JS = new JavaScriptSerializer();
var data = JS.Deserialize <JobPortal>(modelStr);
careerdetail _objcareerdetails = new careerdetail();
Guid ID = Guid.NewGuid();
_objcareerdetails.PK_MemberID = ID;
_objcareerdetails.FullName = data.FullName;
_objcareerdetails.AdditionalInformation = data.AdditionalInfo;
if (result.FileData != null)
{
var files = result.FileData;
string filename = files[0].LocalFileName;
byte[] imageData; var imagestring = "";
using (FileStream file = new FileStream(filename, FileMode.Open, FileAccess.Read))
{
BinaryReader br = new BinaryReader(file);
imageData = br.ReadBytes((int)file.Length);
imagestring = Convert.ToBase64String(imageData.ToArray());
// bytes = new byte[file.Length];
// file.Read(bytes, 0, (int)file.Length);
}
_objcareerdetails.Resume = imagestring;
}
_objcareerdetails.CareerObjective = data.CarrierObjective;
_objcareerdetails.SpecialQualification = data.SpecialQualification;
_objcareerdetails.Declaration = data.declaration;
_objcareerdetails.createdon = DateTime.Now;
_objcareerdetails.EmailAlert = data.emailAlert;
_jobdetails.careerdetails.Add(_objcareerdetails);
foreach (var workhistory in data.workHistry)
{
workhistory _objworkhistory = new workhistory();
_objworkhistory.PK_WorkHistoryID = Guid.NewGuid();
_objworkhistory.FK_MemberID = ID;
_objworkhistory.CompanyName = workhistory.companyName;
_objworkhistory.Desgination = workhistory.designation;
_objworkhistory.JobDescription = workhistory.jobDescription;
//foreach (var timeperiod in workhistory.timePeriod)
//{
if (workhistory.timePeriod.fromDate != "" && workhistory.timePeriod.fromDate != null)
{
_objworkhistory.TimePeriod_From = Convert.ToDateTime(workhistory.timePeriod.fromDate);
}
if (workhistory.timePeriod.toDate != "" && workhistory.timePeriod.toDate != null)
{
_objworkhistory.TimePeriod_To = Convert.ToDateTime(workhistory.timePeriod.toDate);
}
//}
_jobdetails.workhistories.Add(_objworkhistory);
}
foreach (var education in data.educationBackground)
{
educationdetail _objeducationdetails = new educationdetail();
_objeducationdetails.PK_EducationDetailsID = Guid.NewGuid();
_objeducationdetails.FK_MemberID = ID;
_objeducationdetails.InstituteName = education.instituteName;
_objeducationdetails.Degree = education.degree;
_objeducationdetails.Ed_Description = education.designation;
//foreach (var timeperiod in education.timePeriod)
//{
if (education.timePeriod.fromDate != "" && education.timePeriod.fromDate != null)
{
_objeducationdetails.TimePeriod_From = Convert.ToDateTime(education.timePeriod.fromDate);
}
if (education.timePeriod.toDate != "" && education.timePeriod.toDate != null)
{
_objeducationdetails.TimePeriod_To = Convert.ToDateTime(education.timePeriod.toDate);
}
//}
_jobdetails.educationdetails.Add(_objeducationdetails);
}
foreach (var Language in data.language)
{
languageproficiency _objLanguage = new languageproficiency();
_objLanguage.PK_LanguageProficiencyID = Guid.NewGuid();
_objLanguage.FK_MemberID = ID;
_objLanguage.LanguageName = Language.languageName;
if (Language.rating != null && Language.rating != "")
{
_objLanguage.Rating = Convert.ToDecimal(Language.rating);
}
_jobdetails.languageproficiencies.Add(_objLanguage);
}
foreach (var personaldetail in data.personalDetails)
{
personaldetail _objpersonal = new personaldetail();
_objpersonal.PK_MemberUserID = Guid.NewGuid();
_objpersonal.FK_MemberID = ID;
FullName = personaldetail.LastName;
_objpersonal.LastName = personaldetail.LastName;
_objpersonal.MotherName = personaldetail.motherName;
_objpersonal.FatherName = personaldetail.fatherName;
_objpersonal.DOB = Convert.ToDateTime(personaldetail.dateOfBirth);
_objpersonal.BirthPlace = personaldetail.birthPlace;
_objpersonal.Nationality = personaldetail.nationality;
Email = data.email;
_objpersonal.email = data.email;
_objpersonal.PhoneNumber = data.phoneNumber;
_objpersonal.Sex = personaldetail.sex;
_objpersonal.Address = personaldetail.address;
_jobdetails.personaldetails.Add(_objpersonal);
}
_jobdetails.SaveChanges();
isvalid = true;
// SendChangePasswordMail(Email, FullName);
Thread MailThread = new Thread(() => SendChangePasswordMail(Email, FullName));
MailThread.IsBackground = true;
MailThread.Start();
}
}
catch (Exception ex)
{
WebApiApplication._log.LogErrorFormat("MyPortal : {0}", ex);
isvalid = false;
}
return(isvalid);
}
partial void Deleteworkhistory(workhistory instance);
partial void Updateworkhistory(workhistory instance);
partial void Insertworkhistory(workhistory instance);
