public ApiResponse <HrViewModels> GetByEmail(string email, ClientContext clientContext)
{
var apiResponse = new ApiResponse <HrViewModels>();
try
{
var listItems = new List <HrViewModels>();
var hrRes = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListHr));
var query = new CamlQuery {
ViewXml = string.Format(HrView.GetHr.GetByCompanyEmail, email)
};
var hrItemQuery = hrRes.Query(query, (item) => new HrSpModels(hrRes, item)).ToArray();
//.Where(x=>x.CompanyEmail==email).ToArray();
if (hrItemQuery.Length == 0)
{
apiResponse.ErrorMessage = new[] { Message.MessageApi.NoItem };
apiResponse.ErrorType = 400;
return(apiResponse);
}
foreach (var itemQuery in hrItemQuery)
{
GetItemModels(listItems, itemQuery, _clientContext);
}
apiResponse.Content = listItems;
return(apiResponse);
}
catch (Exception e)
{
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = new[] { e.Message };
return(apiResponse);
}
}
public ApiResponse <string> InsertResultDetailFlightAttendant(List <ResultDetailFlightAttendantRequestViewModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListResultDetailFlightAttendant));
foreach (var x in data)
{
try
{
var newItem = new ResultDetailFlightAttendantSpModels(res, null)
{
Result = x.Result,
Avarage = x.Avarage,
Note = x.Note,
Deadline = x.Deadline
};
if (x.EmployeeCode != null)
{
newItem.EmployeeCode = new FieldLookupValue
{
LookupId = x.EmployeeCode.LookupId
}
}
;
if (x.Assessor != null)
{
newItem.Assessor = new FieldLookupValue
{
LookupId = x.Assessor.LookupId
}
}
;
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
if (apiResponse.ErrorType != 400)
{
apiResponse.Content = new[] { Message.MessageApi.Success }
}
;
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public DepartmentSPModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[DepartmentSPModelsField.InternalName.Title]?.ToString();
Code = item.FieldValues[DepartmentSPModelsField.InternalName.Code]?.ToString();
}
public TitleTemplateSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[TitleTemplateField.InternalName.Title]?.ToString();
Code = item.FieldValues[TitleTemplateField.InternalName.Title]?.ToString();
}
public ApiResponse <string> InsertProfile(List <FlightAttendantProfileRequestViewModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListFlightAttendantProfile));
foreach (var x in data)
{
try
{
var newItem = new FlightAttendantProfileSpModels(res, null)
{
WorkingDate = x.WorkingDate,
FlightCode = x.FlightCode,
FlightDate = x.FlightDate,
FlightTimeUTC = x.FlightTimeUTC,
FlightTimeLocal = x.FlightTimeLocal,
Departure = x.Departure,
Destination = x.Destination,
DutyCode = x.DutyCode,
CrewId = x.CrewId,
EmployeeMission = x.EmployeeMission
};
newItem.FlightAttendantCode = new FieldLookupValue
{
LookupId = x.FlightAttendantCodeId
};
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
if (apiResponse.ErrorType != 400)
{
apiResponse.Content = new[] { Message.MessageApi.Success }
}
;
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public HrSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
EmployeeCode = item.FieldValues[HrSpModelsField.InternalName.EmployeeCode]?.ToString();
FullName = item.FieldValues[HrSpModelsField.InternalName.FullName]?.ToString();
CompanyEmail = item.FieldValues[HrSpModelsField.InternalName.CompanyEmail]?.ToString();
NickName = item.FieldValues[HrSpModelsField.InternalName.NickName]?.ToString();
PersonalPhone = item.FieldValues[HrSpModelsField.InternalName.PersonalPhone]?.ToString();
PersonalEmail = item.FieldValues[HrSpModelsField.InternalName.PersonalEmail]?.ToString();
DateOfBirth = Convert.ToDateTime(item.FieldValues[HrSpModelsField.InternalName.DateOfBirth]);
Relationship = item.FieldValues[HrSpModelsField.InternalName.Relationship] as string[];
PermanetAddress = item.FieldValues[HrSpModelsField.InternalName.PermanetAddress]?.ToString();
TemporaryAddress = item.FieldValues[HrSpModelsField.InternalName.TemporaryAddress]?.ToString();
Group = item.FieldValues[HrSpModelsField.InternalName.Group]?.ToString();
Department = item.FieldValues[HrSpModelsField.InternalName.Department]?.ToString();
WorkingAddress = item.FieldValues[HrSpModelsField.InternalName.WorkingAddress]?.ToString();
Role = item.FieldValues[HrSpModelsField.InternalName.Role]?.ToString();
StartingDate = Convert.ToDateTime(item.FieldValues[HrSpModelsField.InternalName.StartingDate]);
Status = item.FieldValues[HrSpModelsField.InternalName.Status] as string[];
WorkingPhone = item.FieldValues[HrSpModelsField.InternalName.WorkingPhone]?.ToString();
Level = item.FieldValues[HrSpModelsField.InternalName.Level]?.ToString();
LineManager = item.FieldValues[HrSpModelsField.InternalName.LineManager]?.ToString();
LatestChangeDate = Convert.ToDateTime(item.FieldValues[HrSpModelsField.InternalName.LatestChangeDate]);
ChangedModified = item.FieldValues[HrSpModelsField.InternalName.ChangedModified]?.ToString();
ExpiredDate = Convert.ToDateTime(item.FieldValues[HrSpModelsField.InternalName.ExpiredDate]);
Experience = item.FieldValues[HrSpModelsField.InternalName.Experience]?.ToString();
Education = item.FieldValues[HrSpModelsField.InternalName.Education]?.ToString();
CompanyAssets = item.FieldValues[HrSpModelsField.InternalName.CompanyAssets]?.ToString();
LeavingReason = item.FieldValues[HrSpModelsField.InternalName.LeavingReason]?.ToString();
Taxno = item.FieldValues[HrSpModelsField.InternalName.Taxno]?.ToString();
SocialInsurantNumber = item.FieldValues[HrSpModelsField.InternalName.SocialInsurantNumber]?.ToString();
if (item[HrSpModelsField.InternalName.Image] != null)
{
Image = item[HrSpModelsField.InternalName.Image]?.ToString();
}
if (item[HrSpModelsField.InternalName.LeavingAllowedNumber] != null)
{
LeavingAllowedNumber = Convert.ToInt32(item[HrSpModelsField.InternalName.LeavingAllowedNumber]);
}
if (item[HrSpModelsField.InternalName.TicketsNumberIssued] != null)
{
TicketsNumberIssued = Convert.ToInt32(item[HrSpModelsField.InternalName.TicketsNumberIssued]);
}
}
public ResultFlightSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[ResultFlightField.InternalName.Title]?.ToString();
StaffId = item.FieldValues[ResultFlightField.InternalName.StaffId] as FieldLookupValue;
IdentifyName = item.FieldValues[ResultFlightField.InternalName.IdentifyName]?.ToString();
FullName = item.FieldValues[ResultFlightField.InternalName.FullName]?.ToString();
PositonName = item.FieldValues[ResultFlightField.InternalName.PositonName]?.ToString();
Result = item.FieldValues[ResultFlightField.InternalName.Result]?.ToString();
Note = item.FieldValues[ResultFlightField.InternalName.Note]?.ToString();
Avarage = Convert.ToDouble(item.FieldValues[ResultFlightField.InternalName.Avarage]);
}
public ApiResponse <string> InsertWorkingTime(List <WorkingTimeRequestModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListWorkingTime));
foreach (var x in data)
{
try
{
var newItem = new WorkingTimeSpModels(res, null)
{
Title = x.Title,
ShiftCode = x.ShiftCode,
IncomeTime = x.IncomeTime,
OutcomeTime = x.OutcomeTime,
DetailDepartment = x.DetailDepartment
};
if (x.DepartmentId > 0)
{
newItem.Department = new FieldLookupValue
{
LookupId = x.DepartmentId,
}
}
;
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public FlightAttendantTitleSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[FlightAttendantTitleField.InternalName.Title]?.ToString();
EmployeeCode = item.FieldValues[FlightAttendantTitleField.InternalName.EmployeeCode]?.ToString();
EmployeeName = item.FieldValues[FlightAttendantTitleField.InternalName.EmployeeName]?.ToString();
PositionCode = item.FieldValues[FlightAttendantTitleField.InternalName.PositionCode]?.ToString();
PositionName = item.FieldValues[FlightAttendantTitleField.InternalName.PositionName]?.ToString();
if (item.FieldValues[FlightAttendantTitleField.InternalName.EffectiveDate] != null)
{
EffectiveDate = Convert.ToDateTime(item.FieldValues[FlightAttendantTitleField.InternalName.EffectiveDate]);
}
}
public WorkingTimeSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[WorkingTimeSpModelsField.InternalName.Title]?.ToString();
Department = (!string.IsNullOrEmpty(Convert.ToString(item.FieldValues[WorkingTimeSpModelsField.InternalName.Department]))) ?
(FieldLookupValue)item.FieldValues[WorkingTimeSpModelsField.InternalName.Department] : new FieldLookupValue()
{
LookupId = 0
};
ShiftCode = item.FieldValues[WorkingTimeSpModelsField.InternalName.ShiftCode]?.ToString();
IncomeTime = item.FieldValues[WorkingTimeSpModelsField.InternalName.IncomeTime]?.ToString();
OutcomeTime = item.FieldValues[WorkingTimeSpModelsField.InternalName.OutcomeTime]?.ToString();
DetailDepartment = item.FieldValues[WorkingTimeSpModelsField.InternalName.DetailDepartment]?.ToString();
}
public ApiResponse <string> InsertFlightAttendantTitle(List <FlightAttendantTitleRequestViewModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListFlightAttendantTitle));
foreach (var x in data)
{
try
{
var newItem = new FlightAttendantTitleSpModels(res, null)
{
EmployeeCode = x.EmployeeCode,
EmployeeName = x.EmployeeName,
PositionCode = x.PositionCode,
PositionName = x.PositionName,
EffectiveDate = x.EffectiveDate
};
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
if (apiResponse.ErrorType != 400)
{
apiResponse.Content = new[] { Message.MessageApi.Success }
}
;
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public FlightMemberSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[FlightMemberSpModelsField.InternalName.Title]?.ToString();
FlightNumber = Convert.ToInt32(item.FieldValues[FlightMemberSpModelsField.InternalName.FlightNumber]);
if (item.FieldValues[FlightMemberSpModelsField.InternalName.FlightScheduleId] != null)
{
FlightScheduleId = item.FieldValues[FlightMemberSpModelsField.InternalName.FlightScheduleId] as FieldLookupValue;
}
if (item.FieldValues[FlightMemberSpModelsField.InternalName.FlightCreatedAt] != null)
{
FlightCreatedAt = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightMemberSpModelsField.InternalName.FlightCreatedAt]));
}
if (item.FieldValues[FlightMemberSpModelsField.InternalName.FlightUpdatedAt] != null)
{
FlightUpdatedAt = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightMemberSpModelsField.InternalName.FlightUpdatedAt]));
}
if (item.FieldValues[FlightMemberSpModelsField.InternalName.Pilot] != null)
{
Pilot = Convert.ToInt32(item.FieldValues[FlightMemberSpModelsField.InternalName.Pilot]);
}
if (item.FieldValues[FlightMemberSpModelsField.InternalName.Attendant] != null)
{
Attendant = Convert.ToInt32(item.FieldValues[FlightMemberSpModelsField.InternalName.Attendant]);
}
FlightDate = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightMemberSpModelsField.InternalName.FlightDate]));
if (item.FieldValues[FlightMemberSpModelsField.InternalName.FlightId] != null)
{
FlightId = Convert.ToInt32(item.FieldValues[FlightMemberSpModelsField.InternalName.FlightId]);
}
}
public ApiResponse <string> InsertTitleTemplate(List <TitleTemplateRequestViewModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListTitleTemplate));
foreach (var x in data)
{
try
{
var newItem = new TitleTemplateSpModels(res, null)
{
Title = x.Title,
Code = x.Code,
};
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
if (apiResponse.ErrorType != 400)
{
apiResponse.Content = new[] { Message.MessageApi.Success }
}
;
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public FlightAttendantProfileSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[FlightAttendantProfileField.InternalName.Title]?.ToString();
FlightAttendantCode = item.FieldValues[FlightAttendantProfileField.InternalName.FlightAttendantCode] as FieldLookupValue;
FlightCode = item.FieldValues[FlightAttendantProfileField.InternalName.FlightCode]?.ToString();
Departure = item.FieldValues[FlightAttendantProfileField.InternalName.Departure]?.ToString();
Destination = item.FieldValues[FlightAttendantProfileField.InternalName.Destination]?.ToString();
DutyCode = item.FieldValues[FlightAttendantProfileField.InternalName.DutyCode]?.ToString();
CrewId = Convert.ToInt32(item.FieldValues[FlightAttendantProfileField.InternalName.CrewId]);
if (item.FieldValues[FlightAttendantProfileField.InternalName.WorkingDate] != null)
{
WorkingDate = Convert.ToDateTime(item.FieldValues[FlightAttendantProfileField.InternalName.WorkingDate]);
}
if (item.FieldValues[FlightAttendantProfileField.InternalName.FlightDate] != null)
{
FlightDate = Convert.ToDateTime(item.FieldValues[FlightAttendantProfileField.InternalName.FlightDate]);
}
if (item.FieldValues[FlightAttendantProfileField.InternalName.FlightTimeUTC] != null)
{
FlightTimeUTC = Convert.ToDateTime(item.FieldValues[FlightAttendantProfileField.InternalName.FlightTimeUTC]);
}
if (item.FieldValues[FlightAttendantProfileField.InternalName.FlightTimeLocal] != null)
{
FlightTimeLocal = Convert.ToDateTime(item.FieldValues[FlightAttendantProfileField.InternalName.FlightTimeLocal]);
}
if (item.FieldValues[FlightAttendantProfileField.InternalName.EmployeeMission] != null)
{
EmployeeMission = item.FieldValues[FlightAttendantProfileField.InternalName.EmployeeMission] as string[];
}
}
public FlightPassengerSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[FlightPassengerSpModelsField.InternalName.Title]?.ToString();
FlightId = Convert.ToInt32(item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightId]);
EconomySsrCode = item.FieldValues[FlightPassengerSpModelsField.InternalName.EconomySsrCode]?.ToString();
BusinessSsrCode = item.FieldValues[FlightPassengerSpModelsField.InternalName.BusinessSsrCode]?.ToString();
if (item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightScheduleId] != null)
{
FlightScheduleId = item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightScheduleId] as FieldLookupValue;
}
if (item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightCreatedAt] != null)
{
FlightCreatedAt = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightCreatedAt]));
}
if (item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightUpdatedAt] != null)
{
FlightUpdatedAt = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightUpdatedAt]));
}
if (item.FieldValues[FlightPassengerSpModelsField.InternalName.Economy] != null)
{
Economy = Convert.ToInt32(item.FieldValues[FlightPassengerSpModelsField.InternalName.Economy]);
}
if (item.FieldValues[FlightPassengerSpModelsField.InternalName.Business] != null)
{
Business = Convert.ToInt32(item.FieldValues[FlightPassengerSpModelsField.InternalName.Business]);
}
if (item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightNumber] != null)
{
FlightNumber = Convert.ToInt32(item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightNumber]);
}
if (item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightDate] != null)
{
FlightDate = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightPassengerSpModelsField.InternalName.FlightDate]));
}
}
public ReviewCategorySpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[ReviewCategoryField.InternalName.Title]?.ToString();
ReviewCategoryId = item.FieldValues[ReviewCategoryField.InternalName.ReviewCategoryId] as FieldLookupValue;
Phase = item.FieldValues[ReviewCategoryField.InternalName.Phase]?.ToString();
EvaluationCriteria = item.FieldValues[ReviewCategoryField.InternalName.EvaluationCriteria]?.ToString();
Satisfy = item.FieldValues[ReviewCategoryField.InternalName.Satisfy]?.ToString();
NotSatisfy = item.FieldValues[ReviewCategoryField.InternalName.NotSatisfy]?.ToString();
NeedImprove = item.FieldValues[ReviewCategoryField.InternalName.NeedImprove]?.ToString();
Detail = item.FieldValues[ReviewCategoryField.InternalName.Detail]?.ToString();
if (item.FieldValues[ReviewCategoryField.InternalName.EffectiveDate] != null)
{
EffectiveDate = Convert.ToDateTime(item.FieldValues[ReviewCategoryField.InternalName.EffectiveDate]);
}
if (item.FieldValues[ReviewCategoryField.InternalName.EffectiveToDate] != null)
{
EffectiveToDate = Convert.ToDateTime(item.FieldValues[ReviewCategoryField.InternalName.EffectiveToDate]);
}
if (item.FieldValues[ReviewCategoryField.InternalName.CreatedUser] != null)
{
CreatedUser = item.FieldValues[ReviewCategoryField.InternalName.CreatedUser] as FieldLookupValue;
}
if (item.FieldValues[ReviewCategoryField.InternalName.BeReviewedUser] != null)
{
BeReviewedUser = item.FieldValues[ReviewCategoryField.InternalName.BeReviewedUser] as FieldLookupValue;
}
if (item.FieldValues[ReviewCategoryField.InternalName.BeReviewedUser] != null)
{
Status = item.FieldValues[ReviewCategoryField.InternalName.Status] as string[];
}
}
public ApiResponse <string> InsertTimeKeeping(List <TimeKeepingInsertModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListTimeKeeping));
foreach (var x in data)
{
try
{
var newItem = new TimeKeepingSPModels(res, null)
{
DeviceName = x.device_name,
UserId = x.user_id,
TimeKeepingDateTime = Convert.ToDateTime(x.date + " " + x.time),
CreateTimeAt = x.created_at,
UpdatedTimeAt = x.updated_at,
EmployeeEmail = x.user_email
};
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public TimeKeepingSPModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
DeviceName = item.FieldValues[TimeKeepingSPModelsField.InternalName.DeviceName]?.ToString();
UserId = item.FieldValues[TimeKeepingSPModelsField.InternalName.UserId]?.ToString();
if (item.FieldValues[TimeKeepingSPModelsField.InternalName.TimeKeepingDateTime] != null)
{
TimeKeepingDateTime = Convert.ToDateTime(item.FieldValues[TimeKeepingSPModelsField.InternalName.TimeKeepingDateTime]);
}
if (item.FieldValues[TimeKeepingSPModelsField.InternalName.CreateTimeAt] != null)
{
CreateTimeAt = Convert.ToDateTime(item.FieldValues[TimeKeepingSPModelsField.InternalName.CreateTimeAt]);
}
if (item.FieldValues[TimeKeepingSPModelsField.InternalName.UpdatedTimeAt] != null)
{
UpdatedTimeAt = Convert.ToDateTime(item.FieldValues[TimeKeepingSPModelsField.InternalName.UpdatedTimeAt]);
}
EmployeeEmail = item.FieldValues[TimeKeepingSPModelsField.InternalName.EmployeeEmail]?.ToString();
}
public ResultDetailFlightAttendantSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
Title = item.FieldValues[ResultDetailFlightAttendantField.InternalName.Title]?.ToString();
EmployeeCode = item.FieldValues[ResultDetailFlightAttendantField.InternalName.EmployeeCode] as FieldLookupValue;
Result = item.FieldValues[ResultDetailFlightAttendantField.InternalName.Result]?.ToString();
Note = item.FieldValues[ResultDetailFlightAttendantField.InternalName.Note]?.ToString();
if (item.FieldValues[ResultDetailFlightAttendantField.InternalName.Avarage] != null)
{
Avarage = Convert.ToDouble(item.FieldValues[ResultDetailFlightAttendantField.InternalName.Avarage]);
}
if (item.FieldValues[ResultDetailFlightAttendantField.InternalName.Assessor] != null)
{
Assessor = item.FieldValues[ResultDetailFlightAttendantField.InternalName.Assessor] as FieldLookupValue;
}
if (item.FieldValues[ResultDetailFlightAttendantField.InternalName.Deadline] != null)
{
Deadline = Convert.ToInt32(item.FieldValues[ResultDetailFlightAttendantField.InternalName.Deadline]);
}
}
public ApiResponse <string> InsertDepartment(List <DepartmentRequestModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListDepartment));
foreach (var x in data)
{
try
{
var newItem = new DepartmentSPModels(res, null)
{
Title = x.Title,
Code = x.Code
};
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public static HrSpModels[] GetHr(ClientContext clientContext)
{
var itemRes = new SPRespository(clientContext, BuildUrlList(clientContext, BambooAirewayBE.API.Utilities.Constants.Constants.ListSPJob.HrUrl));
return(itemRes.GetAll((item) => new HrSpModels(itemRes, item)).ToArray());
}
public static DepartmentSPModels[] GetDepartment(ClientContext clientContext)
{
var departmentRes = new SPRespository(clientContext, BuildUrlList(clientContext, BambooAirewayBE.API.Utilities.Constants.Constants.ListSPJob.DepartmentUrl));
return(departmentRes.GetAll((item) => new DepartmentSPModels(departmentRes, item)).ToArray());
}
public static WorkingTimeSpModels[] GetWorkingTime(ClientContext clientContext)
{
var workingTimeRes = new SPRespository(clientContext, BuildUrlList(clientContext, BambooAirewayBE.API.Utilities.Constants.Constants.ListSPJob.WorkingTimeUrl));
return(workingTimeRes.GetAll((item) => new WorkingTimeSpModels(workingTimeRes, item)).ToArray());
}
public ApiResponse <string> InsertReviewCategory(List <ReviewCategoryRequestViewModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListReviewCategory));
foreach (var x in data)
{
try
{
var newItem = new ReviewCategorySpModels(res, null)
{
Phase = x.Phase,
EvaluationCriteria = x.EvaluationCriteria,
Satisfy = x.Satisfy,
NotSatisfy = x.NotSatisfy,
NeedImprove = x.NeedImprove,
Detail = x.Detail,
EffectiveDate = x.EffectiveDate,
EffectiveToDate = x.EffectiveToDate,
Status = x.Status
};
if (x.ReviewCategoryId != null)
{
newItem.ReviewCategoryId = new FieldLookupValue
{
LookupId = x.ReviewCategoryId.LookupId
}
}
;
if (x.CreatedUser != null)
{
newItem.CreatedUser = new FieldLookupValue
{
LookupId = x.CreatedUser.LookupId
}
}
;
if (x.BeReviewedUser != null)
{
newItem.BeReviewedUser = new FieldLookupValue
{
LookupId = x.BeReviewedUser.LookupId
}
}
;
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
if (apiResponse.ErrorType != 400)
{
apiResponse.Content = new[] { Message.MessageApi.Success }
}
;
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
public static TimeKeepingSPModels[] GetTimeKeeping(ClientContext clientContext)
{
var timeKeepingRes = new SPRespository(clientContext, BuildUrlList(clientContext, BambooAirewayBE.API.Utilities.Constants.Constants.ListSPJob.TimeKeepingUrl));
return(timeKeepingRes.GetAll <TimeKeepingSPModels>((item) => new TimeKeepingSPModels(timeKeepingRes, item)).ToArray());
}
public static ResultFlightSpModels[] GetResultFlight(ClientContext clientContext)
{
var res = new SPRespository(clientContext, BambooAirwayBE.API.Utilities.Utils.Utils.BuildUrlList(clientContext, ListConstant.ListSPs.ListResultFlight));
return(res.GetAll((item) => new ResultFlightSpModels(res, item)).ToArray());
}
public static TitleTemplateSpModels[] GetTitleTemplate(ClientContext clientContext)
{
var res = new SPRespository(clientContext, BambooAirwayBE.API.Utilities.Utils.Utils.BuildUrlList(clientContext, ListConstant.ListSPs.ListTitleTemplate));
return(res.GetAll((item) => new TitleTemplateSpModels(res, item)).ToArray());
}
public static FlightAttendantProfileSpModels[] GetFlightAttendantProfile(ClientContext clientContext)
{
var res = new SPRespository(clientContext, BambooAirwayBE.API.Utilities.Utils.Utils.BuildUrlList(clientContext, ListConstant.ListSPs.ListFlightAttendantProfile));
return(res.GetAll((item) => new FlightAttendantProfileSpModels(res, item)).ToArray());
}
public FlightScheduleSpModels(SPRespository respository, ListItem item) : base(respository, item)
{
if (item == null)
{
return;
}
Id = item.Id;
FlightId = item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightId]?.ToString();
AircraftId = item.FieldValues[FlightScheduleSpModelsField.InternalName.AircraftId]?.ToString();
FlightNumber = item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightNumber]?.ToString();
Status = item.FieldValues[FlightScheduleSpModelsField.InternalName.Status]?.ToString();
DepartureGate = item.FieldValues[FlightScheduleSpModelsField.InternalName.DepartureGate]?.ToString();
BoardingStatus = item.FieldValues[FlightScheduleSpModelsField.InternalName.BoardingStatus]?.ToString();
BoardingTime = item.FieldValues[FlightScheduleSpModelsField.InternalName.BoardingTime]?.ToString();
Origin = item.FieldValues[FlightScheduleSpModelsField.InternalName.Origin]?.ToString();
Destination = item.FieldValues[FlightScheduleSpModelsField.InternalName.Destination]?.ToString();
Route = item.FieldValues[FlightScheduleSpModelsField.InternalName.Route]?.ToString();
FlightReg = item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightReg]?.ToString();
FlightAcType = item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightAcType]?.ToString();
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightCreatedAt] != null)
{
FlightCreatedAt = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightCreatedAt]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightUpdatedAt] != null)
{
FlightUpdatedAt = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightUpdatedAt]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDateGMT0] != null)
{
FlightDateGMT0 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDateGMT0]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDateGMT5] != null)
{
FlightDateGMT5 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDateGMT5]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDateGMT7] != null)
{
FlightDateGMT7 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDateGMT7]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDate] != null)
{
FlightDate = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightDate]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.DepartureDate] != null)
{
DepartureDate = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.DepartureDate]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.DepartureDateGMT0] != null)
{
DepartureDateGMT0 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.DepartureDateGMT0]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.DepartureDateGmt7] != null)
{
DepartureDateGmt7 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.DepartureDateGmt7]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtd] != null)
{
FlightEtd = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtd]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtdGmt0] != null)
{
FlightEtdGmt0 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtdGmt0]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtdGmt7] != null)
{
FlightEtdGmt7 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtdGmt7]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStd] != null)
{
FlightStd = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStd]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStdGmt0] != null)
{
FlightStdGmt0 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStdGmt0]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStdGmt7] != null)
{
FlightStdGmt7 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStdGmt7]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEta] != null)
{
FlightEta = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEta]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtaGmt0] != null)
{
FlightEtaGmt0 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtaGmt0]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtaGmt7] != null)
{
FlightEtaGmt7 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightEtaGmt7]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightSta] != null)
{
FlightSta = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightSta]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStaGmt0] != null)
{
FlightStaGmt0 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStaGmt0]));
}
if (item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStaGmt7] != null)
{
FlightStaGmt7 = DateTimeHelper.ConvertToLocalDatetime(Convert.ToDateTime(item.FieldValues[FlightScheduleSpModelsField.InternalName.FlightStaGmt7]));
}
}
public ApiResponse <string> InsertResultFlight(List <ResultFlightRequestViewModels> data, ClientContext clientContext)
{
var apiResponse = new ApiResponse <string>();
var arrMessage = new List <string>();
try
{
var res = new SPRespository(clientContext, Utils.BuildUrlList(clientContext, ListSPs.ListResultFlight));
foreach (var x in data)
{
try
{
var newItem = new ResultFlightSpModels(res, null)
{
IdentifyName = x.IdentifyName,
FullName = x.FullName,
PositonName = x.PositonName,
Result = x.Result,
Avarage = x.Avarage,
Note = x.Note,
};
if (x.StaffId != null)
{
newItem.StaffId = new FieldLookupValue
{
LookupId = x.StaffId.LookupId,
}
}
;
if (x.Creator != null)
{
newItem.Creator = new FieldLookupValue
{
LookupId = x.Creator.LookupId,
}
}
;
res.AddOrUpdate(newItem);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
}
}
if (apiResponse.ErrorType != 400)
{
apiResponse.Content = new[] { Message.MessageApi.Success }
}
;
return(apiResponse);
}
catch (Exception e)
{
arrMessage.Add(e.Message);
apiResponse.ErrorType = 400;
apiResponse.ErrorMessage = arrMessage;
return(apiResponse);
}
}
