Beispiel #1
0
        public IEnumerable <RetName> Regis_Step_Three(insert_Step_Three item)
        {
            List <RetName> results = new List <RetName>();

            try
            {
                using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
                {
                    var str = (from xx in bx.STEP_THREE_DETAILs
                               where xx.USERNO == item.USERNO
                               select xx).FirstOrDefault();

                    int Status;
                    if (str == null)
                    {
                        InsertData_Three(item);
                        Status = 1;
                    }
                    else
                    {
                        UpdateData_Three(item);
                        InsertData_Three(item);
                        Status = 2;
                    }

                    RetName res = new RetName();
                    res.status = "S";
                    if (Status == 1)
                    {
                        res.message = "Insert success";
                    }
                    else if (Status == 2)
                    {
                        res.message = "Update success";
                    }
                    res.USERNO = item.USERNO;
                    results.Add(res);
                }
            }
            catch (Exception ex)
            {
                RetName res = new RetName();
                res.status  = "F";
                res.message = ex.Message;
                results.Add(res);
            }

            return(results.ToArray());
        }
Beispiel #2
0
        private string UpdateData_Three(insert_Step_Three item)
        {
            string USERNO;

            using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
            {
                try
                {
                    var value_Eduction = (from xx in bx.STEP_THREE_EDUCTIONs
                                          where xx.USERNO == item.USERNO
                                          select xx);

                    foreach (var ux in value_Eduction)
                    {
                        bx.STEP_THREE_EDUCTIONs.DeleteOnSubmit(ux);
                    }
                    bx.SubmitChanges();

                    //----------------------------------------------------------------------------------

                    var value_Training = (from xx in bx.STEP_THREE_TRAININGs
                                          where xx.USERNO == item.USERNO
                                          select xx);

                    foreach (var ux in value_Training)
                    {
                        bx.STEP_THREE_TRAININGs.DeleteOnSubmit(ux);
                    }
                    bx.SubmitChanges();

                    //----------------------------------------------------------------------------------

                    //STEP_THREE_DETAIL value_Detail = new STEP_THREE_DETAIL();
                    var value_Detail = (from xx in bx.STEP_THREE_DETAILs
                                        where xx.USERNO == item.USERNO
                                        select xx).FirstOrDefault();

                    bx.STEP_THREE_DETAILs.DeleteOnSubmit(value_Detail);
                    bx.SubmitChanges();

                    //----------------------------------------------------------------------------------

                    //List<Step_Three_LANGUAGE> Language = new List<Step_Three_LANGUAGE>();
                    var value_Language = (from xx in bx.STEP_THREE_LANGUAGEs
                                          where xx.USERNO == item.USERNO
                                          select xx);

                    foreach (var ux in value_Language)
                    {
                        bx.STEP_THREE_LANGUAGEs.DeleteOnSubmit(ux);
                    }
                    bx.SubmitChanges();

                    //----------------------------------------------------------------------------------


                    //List<Step_Three_EMPLOYMENT> Employment = new List<Step_Three_EMPLOYMENT>();
                    var value_Employment = (from xx in bx.STEP_THREE_EMPLOYMENTs
                                            where xx.USERNO == item.USERNO
                                            select xx);

                    foreach (var ux in value_Employment)
                    {
                        bx.STEP_THREE_EMPLOYMENTs.DeleteOnSubmit(ux);
                    }
                    bx.SubmitChanges();
                }
                catch (Exception ex)
                {
                    throw new ArgumentException(
                              $"{ex.Message} ");
                }
            }
            //}
            return(USERNO = item.USERNO);
        }
Beispiel #3
0
        private string InsertData_Three(insert_Step_Three item)
        {
            string USERNO;

            using (TransactionScope ts = new TransactionScope())
            {
                using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
                {
                    try
                    {
                        USERNO = item.USERNO;
                        var Step_Three_Training   = new STEP_THREE_TRAINING();
                        var Step_Three_Language   = new STEP_THREE_LANGUAGE();
                        var Step_Three_Employment = new STEP_THREE_EMPLOYMENT();
                        var Step_Three_Detail     = new STEP_THREE_DETAIL();

                        //----------------------------------------------------------------------------------

                        //List<Step_Three_EDUCTION> Eduction = new List<Step_Three_EDUCTION>();

                        foreach (var ux in item.Eduction)
                        {
                            STEP_THREE_EDUCTION value_Eduction = new STEP_THREE_EDUCTION();

                            value_Eduction.USERNO         = item.USERNO;
                            value_Eduction.EDUCATION_LV   = ux.EDUCATION_LV;
                            value_Eduction.EDUCATION_NAME = ux.EDUCATION_NAME;
                            value_Eduction.DEGREE         = ux.DEGREE;
                            value_Eduction.S_YEAR         = ux.S_YEAR;
                            value_Eduction.E_YEAR         = ux.E_YEAR;
                            value_Eduction.GPA            = ux.GPA;
                            value_Eduction.MAJOR          = ux.MAJOR;
                            value_Eduction.FLAG           = 0;

                            bx.STEP_THREE_EDUCTIONs.InsertOnSubmit(value_Eduction);
                            bx.SubmitChanges();
                        }

                        //----------------------------------------------------------------------------------

                        //List<Step_Three_TRAINING> Training = new List<Step_Three_TRAINING>();

                        foreach (var ux in item.Training)
                        {
                            STEP_THREE_TRAINING value_Training = new STEP_THREE_TRAINING();

                            value_Training.USERNO      = item.USERNO;
                            value_Training.DATE        = ux.DATE.AddYears(543);
                            value_Training.COURSE      = ux.COURSE;
                            value_Training.INSTITUTION = ux.INSTITUTION;
                            value_Training.S_DATE      = ux.S_DATE.AddYears(543);
                            value_Training.E_DATE      = ux.E_DATE.AddYears(543);
                            value_Training.FLAG        = 0;

                            bx.STEP_THREE_TRAININGs.InsertOnSubmit(value_Training);
                            bx.SubmitChanges();
                        }

                        //----------------------------------------------------------------------------------

                        STEP_THREE_DETAIL value_Detail = new STEP_THREE_DETAIL();

                        value_Detail.USERNO      = item.USERNO;
                        value_Detail.STUDY_NAME  = item.Detail.STUDY_NAME;
                        value_Detail.STUDY_MAJOR = item.Detail.STUDY_MAJOR;
                        value_Detail.HOBBY_ROW1  = item.Detail.HOBBY_ROW1;
                        value_Detail.HOBBY_ROW2  = item.Detail.HOBBY_ROW2;
                        value_Detail.HOBBY_ROW3  = item.Detail.HOBBY_ROW3;
                        value_Detail.HOBBY_ROW4  = item.Detail.HOBBY_ROW4;
                        value_Detail.FLAG        = 0;

                        bx.STEP_THREE_DETAILs.InsertOnSubmit(value_Detail);
                        bx.SubmitChanges();

                        //----------------------------------------------------------------------------------

                        //List<Step_Three_LANGUAGE> Language = new List<Step_Three_LANGUAGE>();

                        foreach (var ux in item.Language)
                        {
                            STEP_THREE_LANGUAGE value_Language = new STEP_THREE_LANGUAGE();

                            value_Language.USERNO   = item.USERNO;
                            value_Language.LANGUAGE = ux.LANGUAGE;
                            value_Language.SPEAKING = ux.SPEAKING;
                            value_Language.READING  = ux.READING;
                            value_Language.WRITING  = ux.WRITING;
                            value_Language.FLAG     = 0;

                            bx.STEP_THREE_LANGUAGEs.InsertOnSubmit(value_Language);
                            bx.SubmitChanges();
                        }

                        //----------------------------------------------------------------------------------


                        //List<Step_Three_EMPLOYMENT> Employment = new List<Step_Three_EMPLOYMENT>();

                        foreach (var ux in item.Employment)
                        {
                            STEP_THREE_EMPLOYMENT value_Employment = new STEP_THREE_EMPLOYMENT();

                            value_Employment.USERNO       = item.USERNO;
                            value_Employment.COMPANY_NAME = ux.COMPANY_NAME;
                            value_Employment.S_DATE       = ux.S_DATE;
                            value_Employment.E_DATE       = ux.E_DATE;
                            value_Employment.POSITION     = ux.POSITION;
                            value_Employment.DETAIL       = ux.DETAIL;
                            value_Employment.LEAVING      = ux.LEAVING;
                            value_Employment.FLAG         = 0;

                            bx.STEP_THREE_EMPLOYMENTs.InsertOnSubmit(value_Employment);
                            bx.SubmitChanges();
                        }

                        ts.Complete();
                    }
                    catch (Exception ex)
                    {
                        throw new ArgumentException(
                                  $"{ex.Message} ");
                    }
                }
            }
            return(USERNO);
        }