// Update -------------------------------------------------------------------------------------------------------------
private string UpdateData_One(insert_Step_One item)
{
string USERNO;
//using (TransactionScope ts = new TransactionScope())
//{
using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
{
try
{
var str = (from xx in bx.STEP_ONEs
where xx.USERNO == item._USERNO
select xx).FirstOrDefault();
bx.STEP_ONEs.DeleteOnSubmit(str);
bx.SubmitChanges();
}
catch (Exception ex)
{
throw new ArgumentException(
$"{ex.Message} ");
}
}
//}
return(USERNO = item._USERNO);
}
private string UpdateData_Two(insert_Step_Two item)
{
string USERNO;
using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
{
try
{
var str = (from xx in bx.STEP_TWOs
where xx.USERNO == item.USERNO
select xx).FirstOrDefault();
bx.STEP_TWOs.DeleteOnSubmit(str);
bx.SubmitChanges();
//ts.Complete();
}
catch (Exception ex)
{
throw new ArgumentException(
$"{ex.Message} ");
}
}
//}
return(USERNO = item.USERNO);
}
private string UpdateData_Four(insert_Step_Four item)
{
string USERNO;
using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
{
try
{
var Four = (from xx in bx.STEP_FOURs
where xx.USERNO == item.USERNO
select xx);
foreach (var ux in Four)
{
bx.STEP_FOURs.DeleteOnSubmit(ux);
}
bx.SubmitChanges();
}
catch (Exception ex)
{
throw new ArgumentException(
$"{ex.Message} ");
}
}
return(USERNO = item.USERNO);
}
private string InsertData_Four(insert_Step_Four item)
{
string USERNO;
using (TransactionScope ts = new TransactionScope())
{
using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
{
try
{
//List<Step_Three_TRAINING> Training = new List<Step_Three_TRAINING>();
foreach (var ux in item.Step_Four)
{
STEP_FOUR value_Four = new STEP_FOUR();
value_Four.USERNO = item.USERNO;
value_Four.Q_ID = ux.Q_ID;
value_Four.CHOOSE = ux.CHOOSE;
value_Four.DETAIL_ROW1 = ux.DETAIL_ROW1;
value_Four.DETAIL_ROW2 = ux.DETAIL_ROW2;
value_Four.DETAIL_ROW3 = ux.DETAIL_ROW3;
value_Four.FLAG = 0;
bx.STEP_FOURs.InsertOnSubmit(value_Four);
bx.SubmitChanges();
}
var Starting_date = (from xx in bx.STEP_TWOs
where xx.USERNO == item.USERNO
select xx).FirstOrDefault();
Starting_date.STARTING_DATE = item.STARTINT_DATE;
//bx.STEP_TWOs.InsertOnSubmit(Starting_date);
bx.SubmitChanges();
ts.Complete();
}
catch (Exception ex)
{
throw new ArgumentException(
$"{ex.Message} ");
}
}
}
return(USERNO = item.USERNO);
}
// Insert ---------------------------------------------------------------------------------------------------------------
private string InsertData_One(insert_Step_One item)
{
string USERNO;
using (TransactionScope ts = new TransactionScope())
{
using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
{
try
{
var Step_One = new STEP_ONE();
string tketNo = GenNo();
USERNO = tketNo;
Step_One.USERNO = tketNo;
Step_One.POSITION = item._POSITION;
Step_One.FULLNAME_TH = item._FULLNAME_TH;
Step_One.NICKNAME_TH = item._NICKNAME_TH;
Step_One.FULLNAME_EN = item._FULLNAME_EN;
Step_One.NICKNAME_EN = item._NICKNAME_EN;
Step_One.PEOPLEID = item._PEOPLEID;
Step_One.ZONE = item._ZONE;
Step_One.PROVINCE_BIRTH = item._PROVINCE_BIRTH;
Step_One.BIRTHDATE = item._BIRTHDATE;
Step_One.AGE = item._AGE;
Step_One.WEIGHT = item._WEIGHT;
Step_One.HEIGHT = item._HEIGHT;
Step_One.ADDR_ROW1 = item._ADDR_ROW1;
Step_One.ADDR_ROW2 = item._ADDR_ROW2;
Step_One.ADDR_ROW3 = item._ADDR_ROW3;
Step_One.ADDR_HOME1 = item._ADDR_HOME1;
Step_One.ADDR_HOME2 = item._ADDR_HOME2;
Step_One.ADDR_HOME3 = item._ADDR_HOME3;
Step_One.ADDR_TEL = item._ADDR_TEL;
Step_One.ADDR_MOBILE = item._ADDR_MOBILE;
Step_One.ADDR_EMAIL = item._ADDR_EMAIL;
Step_One.ADDR_PHOTO = item._ADDR_PHOTO;
Step_One.FLAG = 0;
bx.STEP_ONEs.InsertOnSubmit(Step_One);
bx.SubmitChanges();
ts.Complete();
}
catch (Exception ex)
{
throw new ArgumentException(
$"{ex.Message} ");
}
}
}
return(USERNO);
}
private string InsertData_Two(insert_Step_Two item)
{
string USERNO;
using (TransactionScope ts = new TransactionScope())
{
using (Hr_RegisterDataContext bx = new Hr_RegisterDataContext())
{
try
{
var Step_Two = new STEP_TWO();
Step_Two.USERNO = item.USERNO;
USERNO = item.USERNO;
Step_Two.MARITAL = item.MARITAL;
Step_Two.CHILDEN = item.CHILDEN;
Step_Two.SPOUSE_NAME = item.SPOUSE_NAME;
Step_Two.SPOUSE_AGE = item.SPOUSE_AGE;
Step_Two.SPOUSE_OCCUPATION = item.SPOUSE_OCCUPATION;
Step_Two.SPOUSE_OFFICE = item.SPOUSE_OFFICE;
Step_Two.SPOUSE_PHONE = item.SPOUSE_PHONE;
Step_Two.EMERGENCY = item.EMERGENCY;
Step_Two.EMERGENCY_ROW1 = item.EMERGENCY_ROW1;
Step_Two.EMERGENCY_ROW2 = item.EMERGENCY_ROW2;
Step_Two.EMERGENCY_RELATIONSHIP = item.EMERGENCY_RELATIONSHIP;
Step_Two.EMERGENCY_PHONE = item.EMERGENCY_PHONE;
Step_Two.FLAG = 0;
bx.STEP_TWOs.InsertOnSubmit(Step_Two);
bx.SubmitChanges();
ts.Complete();
}
catch (Exception ex)
{
throw new ArgumentException(
$"{ex.Message} ");
}
}
}
return(USERNO);
}
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);
}
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);
}
