// 訓練用
public string createTrainingData(string userName, string taskName, string batchSize, string trainingPath, string algorithm, string deeps)
{
try
{
using (var cn = new SQLiteConnection(cnStr))
{
string strSql = "INSERT INTO TRAINING (TrainNO, UserName, TaskName, BatchSize, DEEPS, ALGORITHMNO, PATH, STATUS, CREATETIME) VALUES (@TrainNO, @UserName, @TaskName, @BatchSize, @DEEPS, @ALGORITHMNO, @PATH, @STATUS, @CREATETIME)";
TRAINING traininData = new TRAINING()
{
TrainNO = Guid.NewGuid().ToString(),
UserName = userName,
TaskName = taskName,
BatchSize = batchSize,
DEEPS = deeps,
ALGORITHMNO = algorithm,
PATH = trainingPath,
STATUS = "CREATE",
CREATETIME = DateTime.Now.ToString(),
};
cn.Execute(strSql, traininData);
};
return("true");//ajax 可回傳 json or 字串
}
catch (Exception ex) {
return(ex.ToString());
}
}
public ActionResult DeleteConfirmed(string id)
{
TRAINING tRAINING = db.TRAININGS.Find(id);
db.TRAININGS.Remove(tRAINING);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TRAINING_ID,TRAINING_NAME,TRAINING_DESC,TRAINING_PLACE,TRAINING_PERIOD,PARENT_TRAINING_ID")] TRAINING tRAINING)
{
if (ModelState.IsValid)
{
db.Entry(tRAINING).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PARENT_TRAINING_ID = new SelectList(db.TRAININGS, "TRAINING_ID", "TRAINING_NAME", tRAINING.PARENT_TRAINING_ID);
return(View(tRAINING));
}
// GET: TRAININGs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TRAINING tRAINING = db.TRAININGS.Find(id);
if (tRAINING == null)
{
return(HttpNotFound());
}
return(View(tRAINING));
}
// GET: TRAININGs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TRAINING tRAINING = db.TRAININGS.Find(id);
if (tRAINING == null)
{
return(HttpNotFound());
}
ViewBag.PARENT_TRAINING_ID = new SelectList(db.TRAININGS, "TRAINING_ID", "TRAINING_NAME", tRAINING.PARENT_TRAINING_ID);
return(View(tRAINING));
}
public void CreateTraining(Training training)
{
var dbTraining = new TRAINING();
dbTraining.TRAINING_INTERNAL_ID = training.Training_Internal_Id;
dbTraining.DURATION = training.Duration;
dbTraining.NOTES = training.Notes;
dbTraining.STARTDATE = DateTime.ParseExact(training.StartDate, "yyyy-MM-dd",
System.Globalization.CultureInfo.InvariantCulture);
dbTraining.TRAININGTHEME = training.TrainingTheme;
dbTraining.TRAININGTYPE = training.TrainingType;
dbTraining.TRAINING_QUALITY = training.TrainingQuality;
dbTraining.RELATIONSHIP = training.Relationship;
_trainingRepo.Add(dbTraining);
_unitOfWork.Commit();
}
public List <Student> getAllStudentsInTraining(string trainingInternalId)
{
var allStudensTraining = _studentTrainingRepo.GetAll();
List <Student> studentsInTraining = new List <Student>();
TRAINING dbTraining = _trainingRepo.Get(t => t.TRAINING_INTERNAL_ID == trainingInternalId);
foreach (STUDENT_TRAINING student_training in allStudensTraining)
{
if (student_training.TRAINING_ID == dbTraining.TRAINING_ID)
{
STUDENT dbStudent = _studentRepo.Get(s => s.PERSON.PERSON_ID == student_training.PERSON_ID);
var student = new Student(dbStudent.STUDENT_INTERNAL_ID, dbStudent.PERSON.FIRSTNAME, dbStudent.PERSON.LASTNAME, dbStudent.PERSON.EMAIL,
dbStudent.PERSON.TELEPHONE, dbStudent.PAYMENTTYPE, (double)dbStudent.DISCOUNT, dbStudent.JMBG, dbStudent.ADDRESS, dbStudent.BORN_DATE.ToString(),
dbStudent.COUNTRY, dbStudent.PARENT_FIRST_NAME, dbStudent.PARENT_LAST_NAME, dbStudent.PARENTS_MAIL, dbStudent.PARENTS_TELEPHONE, dbStudent.IMAGE_URL, (Decimal)dbStudent.ToPay);
studentsInTraining.Add(student);
}
}
return(studentsInTraining);
}
public messageModel insert(projectTrainingScheduleModel value)
{
messageModel result = new messageModel();
using (var context = new StandardCanEntities())
{
var dbContextTransaction = context.Database.BeginTransaction();
try
{
//if (String.IsNullOrEmpty(value.user_id))
//{
// throw new Exception("Unauthorized Access");
//}
//var userId = JwtHelper.GetUserIdFromToken(value.user_id);
//if (String.IsNullOrEmpty(userId))
//{
// throw new Exception("Unauthorized Access");
//}
JavaScriptSerializer js = new JavaScriptSerializer();
string json = js.Serialize(value);
context.interface_log.Add(new interface_log
{
data_log = json,
module = "Training_insert",
update_date = DateTime.Now
});
context.SaveChanges();
var dt = DateTime.Now;
TRAINING training = new TRAINING();
training.TrainingName = value.training_name;
training.TrainingDateFrom = String.IsNullOrEmpty(value.date_form) ? (DateTime?)null : DateTime.ParseExact(value.date_form, "yyyy-MM-dd", CultureInfo.InvariantCulture);
training.TrainingDateTo = String.IsNullOrEmpty(value.date_to) ? (DateTime?)null : DateTime.ParseExact(value.date_to, "yyyy-MM-dd", CultureInfo.InvariantCulture);
training.TrainingStatus = value.training_status;
//training.CreateBy = Convert.ToInt32(userId);
training.CreateDate = dt;
//training.UpdateBy = Convert.ToInt32(userId);
training.UpdateDate = dt;
context.TRAININGs.Add(training);
context.SaveChanges();
result.value = training.TrainingId.ToString();
foreach (var item in value.training_item)
{
TRAINING_ITEM training_item = new TRAINING_ITEM();
training_item.TrainingId = training.TrainingId;
training_item.TrainingCourseId = !String.IsNullOrEmpty(item.course_id) ? Convert.ToInt32(item.course_id) : (int?)null;
training_item.TrainingDestinationId = !String.IsNullOrEmpty(item.destination_id) ? Convert.ToInt32(item.destination_id) : (int?)null;
training_item.TrainingItemDate = String.IsNullOrEmpty(item.item_date) ? (DateTime?)null : DateTime.ParseExact(item.item_date, "yyyy-MM-dd", CultureInfo.InvariantCulture);
training_item.TrainingItemStart = item.time_start ?? "";
training_item.TrainingItemStop = item.time_stop ?? "";
context.TRAINING_ITEM.Add(training_item);
context.SaveChanges();
if (item.expert_list != null)
{
foreach (var expert in item.expert_list)
{
if (!String.IsNullOrEmpty(expert.expert_id))
{
TRAINING_EXPERT training_expert = new TRAINING_EXPERT();
training_expert.TrainingId = training.TrainingId;
training_expert.TrainingItemId = training_item.TrainingItemId;
training_expert.ExpertId = Convert.ToInt32(expert.expert_id);
context.TRAINING_EXPERT.Add(training_expert);
context.SaveChanges();
}
}
}
if (item.expense_list != null)
{
foreach (var expense in item.expense_list)
{
if (!String.IsNullOrEmpty(expense.expense_id))
{
TRAINING_EXPENSE training_expense = new TRAINING_EXPENSE();
training_expense.TrainingId = training.TrainingId;
training_expense.TrainingItemId = training_item.TrainingItemId;
training_expense.ExpenseId = Convert.ToInt32(expense.expense_id);
training_expense.TrainingExpensePrice = String.IsNullOrEmpty(expense.expense_price) ? 0 : Convert.ToDouble(expense.expense_price);
context.TRAINING_EXPENSE.Add(training_expense);
context.SaveChanges();
}
}
}
if (item.emp_list != null)
{
foreach (var emp in item.emp_list)
{
if (!String.IsNullOrEmpty(emp.emp_code))
{
TRAINING_EMP training_emp = new TRAINING_EMP();
training_emp.TrainingId = training.TrainingId;
training_emp.TrainingItemId = training_item.TrainingItemId;
training_emp.TrainingEmpCode = emp.emp_code;
training_emp.TrainingEmpScore1 = emp.emp_score1;
training_emp.TrainingEmpScore2 = emp.emp_score2;
training_emp.TrainingEmpScore3 = emp.emp_score3;
training_emp.TrainingEmpScore4 = emp.emp_score4;
training_emp.TrainingEmpScore5 = emp.emp_score5;
training_emp.TrainingEmpScoreTotal = emp.emp_score_total;
training_emp.TrainingEmpResult = emp.emp_result;
context.TRAINING_EMP.Add(training_emp);
context.SaveChanges();
}
}
}
}
dbContextTransaction.Commit();
result.status = "S";
result.message = "Success";
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
result.status = "E";
result.message = ex.Message.ToString();
}
}
return(result);
}
