private psaUser.psaWorkdayResource Assemble(LinqToExcel.Row myRow)
{
psaUser.psaWorkdayResource myResource = new psaUser.psaWorkdayResource();
myResource.careerInterests = myRow["Career Interests"].ToString();
myResource.citizenship = myRow["Citizenship Status"].ToString();
myResource.city = myRow["Work Address - City"].ToString();
myResource.continuousServiceDate = DateTime.Parse(myRow["Continuous Service Date"].ToString());
myResource.continuousServiceDateSpecified = true;
myResource.costCenter = myRow["Cost Center - ID"].ToString();
myResource.country = myRow["Work Address - Country"].ToString();
string tmpEmail = myRow["Email - Primary Work"].ToString().Replace("@", "=");
myResource.email = tmpEmail + "@example.com";
myResource.firstName = myRow["Preferred Name - First Name"].ToString();
myResource.lastName = myRow["Preferred Name - Last Name"].ToString();
myResource.location = myRow["Work Address - Country"].ToString(); ;// myRow["Location"].ToString();
myResource.managerId = myRow["Manager - Level 01 ID"].ToString();
myResource.mobile = myRow["Mobile Phone"].ToString();
myResource.phone = myRow["Phone - Primary Work"].ToString();
myResource.startDate = DateTime.Parse(myRow["Original Hire Date"].ToString());
myResource.startDateSpecified = true;
myResource.state = myRow["Work Address - State/Province"].ToString();
myResource.stateWitholding = myRow["State Withholding (Resident) - State"].ToString();
string tempStreet = myRow["Work Address - Formatted Line 1"].ToString().TrimEnd() + "," + myRow["Work Address - Formatted Line 2"].ToString().TrimEnd() + "," + myRow["Work Address - Formatted Line 3"].ToString().TrimEnd();
myResource.street = tempStreet;
myResource.title = myRow["Position"].ToString();
myResource.workdDayEmployeeId = myRow["Employee ID"].ToString();
myResource.zip = myRow["Work Address - Postal Code"].ToString();
myResource.currencyISOCode = myRow["Currency for Primary Position"].ToString();
myResource.company = getCompanyData(myResource.costCenter);//"Manhattan Associates - India";
myResource.contingentWorkerType = myRow["Contingent Worker Type"].ToString();
myResource.departmentOwnerId = myRow["Manager - Level 03 ID"].ToString();
DateTime temp;
bool success = DateTime.TryParse(myRow["Last Day of Work"].ToString(), out temp);
myResource.endDate = temp;
myResource.endDateSpecified = success;
myResource.groupLeadAltManagerId = myRow["Manager - Level 02 ID"].ToString();
myResource.isContingentWorker = myRow["Worker is Contingent Worker"].Cast<bool>();
myResource.isContingentWorkerSpecified = true;
myResource.resourceRole = myRow["Work Experience"].ToString();
myResource.techCode = myRow["Workday Account"].ToString();
myResource.tenure = myRow["Length of Service in Months"].ToString();
myResource.workerType = myRow["Position Worker Type"].ToString();
//?????????????????????????????????
//myResource.resourceStatus = myRow[""].ToString();
// myResource.level = myRow[""].ToString();
//myResource.timeType = myRow[""].ToString();
myResource.weeklyScheduledHours = "40";// myRow[""].ToString();
return myResource;
}
protected string getNewValue(mapping p_mapp,LinqToExcel.Row p_row)
{
string new_value = string.Empty;
if (!p_mapp.new_name.Equals("DEFAULT"))
{
//TODO 應該是要用e_name 而不是new_name
//這樣每家客戶不同時，就都要修正 Orz
switch (p_mapp.new_name)
{
case "外勞人數":
case "引進方式":
new_value = p_row[p_mapp.new_name].Value == DBNull.Value
? "0"
: p_row[p_mapp.new_name].Value.ToString();
break;
case "性別":
new_value = p_row[p_mapp.new_name] == "女" ? "'F'" : "'M'";
break;
case "生日":
case "入境日":
case "護照期限":
case "聘可期限":
case "居留期限":
case "護照效期":
case "出生日期":
case "入境日期":
case "實際離境日":
case "居留證效期":
case " 招募函發函日期":
case "聘雇許可函發函日期":
if (p_row[p_mapp.new_name].Value == DBNull.Value)
{
new_value = "{^//}";
}
else
{
new_value = "{^" + Convert.ToDateTime(p_row[p_mapp.new_name]).ToShortDateString() + "}";
}
break;
case "外勞狀態":
new_value = "1";
break;
default:
new_value = string.Format("'{0}'"
, p_row[p_mapp.new_name] == null ? string.Empty : p_row[p_mapp.new_name]);
break;
}
}
else
{
if (p_mapp.e_name.Equals("CUST_SN") || p_mapp.e_name.Equals("LBR_SN"))
{
new_value = cust_sn.ToString();
}
else
{
new_value = getDefaultValue(p_mapp.field_type);
}
}
return new_value;
}
private psaUser.psaWorkdayPTO AssemblePTO(LinqToExcel.Row myRow)
{
psaUser.psaWorkdayPTO myPTO = new psaUser.psaWorkdayPTO();
myPTO.dayOfWeek = DateTime.Parse(myRow["Date"]).DayOfWeek.ToString() ;
myPTO.hours = System.Convert.ToInt32(myRow["Requested"].Value);
myPTO.hoursSpecified = true;
myPTO.timeOffDate = DateTime.Parse(myRow["Date"]);
myPTO.timeOffDateSpecified=true;
myPTO.workDayPTOId = myRow["Spreadsheet Key"].ToString();
myPTO.workdDayEmployeeId = myRow["Employee"].ToString();
return myPTO;
}
private string[] GenerateValuesFromExcelRowNoHeader(LinqToExcel.RowNoHeader row)
{
string[] values = new String[row.ToArray().Length];
var count = 0;
foreach (var value in row.ToArray())
{
values[count] = value.ToString();
count++;
}
return values;
}