Example #1
0
        }                     //End public CPARCRUD()

        public void setCPAR_TYPE(string psCPAR_TYPE)
        {
            this.CPAR_TYPE     = psCPAR_TYPE;
            oCRUDConfig_cparid = new Config_cparidCRUD();
            //oDSConfig_cparid = new Config_cparidDS();
            oDSEmployee = new EmployeeDS();
        } //End public void setCPAR_TYPE(string psCPAR_TYPE)
Example #2
0
        } //End public Task_workerCRUD()

        //Constructor 3
        public Task_workerCRUD(DBMAINContext poDB, TaskCRUD poCRUD, TaskdCRUD poCRUD_detail, TaskdDS poDSDetail,
                               SysinfoDS poDSSysinfo, EmployeeDS poDSEmployee)
        {
            this.db = poDB;
            //CRUD
            this.oCRUD        = poCRUD;
            this.oCRUD_detail = poCRUD_detail;
            //DS
            this.oDSDetail   = poDSDetail;
            this.oDSEmployee = poDSEmployee;
            this.oDSSysinfo  = poDSSysinfo;
        } //End public Task_workerCRUD()
Example #3
0
 //Instantiate
 private void Instantiate()
 {
     //CRUD
     this.oCRUD        = new TaskCRUD(this.db);
     this.oCRUD_detail = new TaskdCRUD(this.db);
     //DS
     this.oDSDetail   = new TaskdDS(this.db);
     this.oDSSysinfo  = new SysinfoDS(this.db);
     this.oDSEmployee = new EmployeeDS(this.db);
     this.oDSMonth    = new MonthDS(this.db);
     this.oDSYear     = new YearDS(this.db);
     //DATA
     this.oData = new TaskVM();
 } //End private void Instantiate()
Example #4
0
        } //End Constructor 1

        //Constructor 2
        public Employee_Validation(EmployeeVM poViewModel, EmployeeDS poDS)
        {
            this.oViewModel = poViewModel;
            this.oDS        = poDS;
            aValidationMSG  = new List <ValidationMSG_VM>();
        } //End Constructor 2
Example #5
0
        }                         //End public ComplainCRUD()

        public void Create(Complain_DetailVM poViewModel)
        {
            string vsMsgErr = "";

            try
            {
                using (var db = new DBMAINContext())
                {
                    Complain oModel = new Complain();
                    //Map Form Data
                    Mapper.CreateMap <Complain_DetailVM, Complain>();
                    oModel = Mapper.Map <Complain_DetailVM, Complain>(poViewModel);
                    //Set Field Header
                    oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set DTA_STS
                    oModel.DTA_STS = valFLAG.FLAG_CRUDOPT_CREATE;
                    //Set CPAR_STS
                    oModel.COMPLAIN_STS = valFLAG.FLAG_CPAR_STS_OPEN;
                    //Set field
                    oModel.setFIELD(valFLAG.FLAG_CRUDOPT_CREATE);

                    //Set outo create CPAR
                    if (oModel.IS_CPAR == valFLAG.FLAG_YES)
                    {
                        EmployeeDS oDSEmployee = new EmployeeDS();
                        CPARCRUD   oCRUD_cpar  = new CPARCRUD();
                        oCRUD_cpar.setCPAR_TYPE(valFLAG.FLAG_CPAR_TYPE_CC);
                        //oCRUD_cpar.Create_prepare();

                        oCRUD_cpar.oModel.AUDITOR_RUID     = null;
                        oCRUD_cpar.oModel.AUDITORDEPT_RUID = null;
                        oCRUD_cpar.oModel.AUDITEE_RUID     = poViewModel.PIC_RUID;
                        oCRUD_cpar.oModel.AUDITEEDEPT_RUID = oDSEmployee.getData_deptruid(oCRUD_cpar.oModel.AUDITEE_RUID);
                        oCRUD_cpar.oModel.CPAR_DT          = poViewModel.ISSUED_DT;
                        oCRUD_cpar.oModel.CPAR_TRGT_DT     = poViewModel.TARGET_DT;
                        oCRUD_cpar.oModel.CPAR_DESC        = poViewModel.DESCRIPTION;
                        oCRUD_cpar.oModel.CPAR_RESOLUTION2 = poViewModel.SOLUTION;
                        oCRUD_cpar.oModel.COMPLAIN_RUID    = oModel.RUID;
                        oCRUD_cpar.Create_prepare();

                        //Update model CPAR
                        db.CPARs.Add(oCRUD_cpar.oModel);
                        //Update model config
                        //db.Entry(oCRUD_cpar.oCRUDConfig_cparid.oModel).State = EntityState.Modified;
                        if (oCRUD_cpar.oModel.isNEW_CONFIG)
                        {
                            db.Config_cparids.Add(oCRUD_cpar.oCRUDConfig_cparid.oModel);
                        } //End if (oModel.isNEW_CONFIG)
                        if (!oCRUD_cpar.oModel.isNEW_CONFIG)
                        {
                            db.Entry(oCRUD_cpar.oCRUDConfig_cparid.oModel).State = EntityState.Modified;
                        } //End if (!oModel.isNEW_CONFIG)
                    }     //End if (this.IS_CPAR == valFLAG.FLAG_YES)

                    //Update model Complain
                    db.Complains.Add(oModel);
                    //Process CRUD
                    db.SaveChanges();
                }                                         //End using
            }                                             //End try
            catch (Exception e) { vsMsgErr = e.Message; } //End catch
        }                                                 //End public void Create