// 訓練用
 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());
     }
 }
Example #2
0
        public ActionResult DeleteConfirmed(string id)
        {
            TRAINING tRAINING = db.TRAININGS.Find(id);

            db.TRAININGS.Remove(tRAINING);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Example #3
0
 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));
 }
Example #4
0
        // 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));
        }
Example #5
0
        // 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));
        }
Example #6
0
        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();
        }
Example #7
0
        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);
        }
Example #8
0
        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);
        }