public int AddMechExamList(kh_examinesModel examModel)
{
using (Entities db = new Entities())
{
kh_examines exams = new kh_examines();
exams.companyid = examModel.companyid;
exams.contractid = examModel.contractid;
exams.examinedate = examModel.examinedate;
exams.score = examModel.score;
exams.status = 0;
exams.createtime = DateTime.Now;
exams.createuserid = examModel.createuserid;
db.kh_examines.Add(exams);
db.SaveChanges();
kh_scores scores = new kh_scores();
scores.examineid = exams.examineid;
if (examModel.scoresList != null)
{
for (int i = 0; i < examModel.scoresList.Count(); i++)
{
scores.deail = examModel.scoresList[i].deail;
scores.deduct = examModel.scoresList[i].deduct;
scores.deductuserid = examModel.createuserid;
scores.examinetime = examModel.scoresList[i].examinetime;
db.kh_scores.Add(scores);
db.SaveChanges();
}
}
return(db.SaveChanges());
}
}
public int ReleaseMechExam(int examineid)
{
using (Entities db = new Entities())
{
kh_examines exams = db.kh_examines.FirstOrDefault(t => t.examineid == examineid);
exams.status = 1;
return(db.SaveChanges());
}
}
public int EditMechExamInf(kh_examinesModel examModel)
{
using (Entities db = new Entities())
{
kh_examines exams = db.kh_examines.FirstOrDefault(t => t.examineid == examModel.examineid);
List <kh_scores> scoresList = db.kh_scores.Where(t => t.examineid == examModel.examineid).ToList();
if (exams != null)
{
for (int i = 0; i < scoresList.Count; i++)
{
db.kh_scores.Remove(scoresList[i]);
db.SaveChanges();
}
exams.score = examModel.score;
kh_scores scores = new kh_scores();
scores.examineid = exams.examineid;
if (examModel.scoresList != null)
{
for (int i = 0; i < examModel.scoresList.Count(); i++)
{
scores.deail = examModel.scoresList[i].deail;
scores.deduct = examModel.scoresList[i].deduct;
scores.deductuserid = examModel.createuserid;
scores.examinetime = examModel.scoresList[i].examinetime;
db.kh_scores.Add(scores);
db.SaveChanges();
}
}
return(db.SaveChanges());
}
else
{
return(0);
}
}
}
