public CreateBranchResponse InsertOrUpdateBranch(InsertOrUpdateBranchRequest request)
{
var stopwatch = System.Diagnostics.Stopwatch.StartNew();
CreateBranchResponse response = new CreateBranchResponse();
Logger.Info(_logMsg.Clear().SetPrefixMsg("Call BranchService.InsertOrUpdateBranch").ToInputLogString());
Logger.Debug("I:--START--:--BranchService.InsertOrUpdateBranch--");
try
{
bool valid = false;
_commonFacade = new CommonFacade();
if (request.Header != null)
{
valid = _commonFacade.VerifyServiceRequest <Header>(request.Header);
response.Header = new Header
{
reference_no = request.Header.reference_no,
service_name = request.Header.service_name,
system_code = request.Header.system_code,
transaction_date = request.Header.transaction_date
};
}
Logger.DebugFormat("-- XMLRequest --\n{0}", request.SerializeObject());
var auditLog = new AuditLogEntity();
auditLog.Module = Constants.Module.WebService;
auditLog.Action = Constants.AuditAction.CreateBranch;
auditLog.IpAddress = ApplicationHelpers.GetClientIP();
#region == Validate Require Field ==
if (!valid)
{
response.StatusResponse = new StatusResponse()
{
ErrorCode = Constants.ErrorCode.CSMBranch001,
Status = Constants.StatusResponse.Failed,
Description = "Bad Request, the header is not valid"
};
return(response);
}
else
{
if (string.IsNullOrEmpty(request.BranchCode))
{
return(GetReturnErrorRequireField("BranchCode", response));
}
if (string.IsNullOrEmpty(request.BranchName))
{
return(GetReturnErrorRequireField("BranchName", response));
}
if (string.IsNullOrEmpty(request.ChannelCode))
{
return(GetReturnErrorRequireField("ChannelCode", response));
}
if (request.StartTimeHour < 0 || request.StartTimeHour > 23)
{
return(GetReturnErrorInvalidFormat("StartTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 23", "5", response));
}
if (request.StartTimeMinute < 0 || request.StartTimeMinute > 59)
{
return(GetReturnErrorInvalidFormat("StartTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 59", "5", response));
}
if (request.EndTimeHour < 0 || request.EndTimeHour > 23)
{
return(GetReturnErrorInvalidFormat("EndTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 23", "5", response));
}
if (request.EndTimeMinute < 0 || request.EndTimeMinute > 59)
{
return(GetReturnErrorInvalidFormat("EndTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 59", "5", response));
}
if (request.Status != 0 && request.Status != 1)
{
return(GetReturnErrorInvalidFormat("Status", "ต้องมีค่าระหว่าง 0 ถึง 1", "5", response));
}
}
#endregion
#region == Validate Code ==
var channelDataAccess = new ChannelDataAccess(_context);
int?channelId = channelDataAccess.GetChannelIdByChannelCode(request.ChannelCode);
if (!channelId.HasValue)
{
response.StatusResponse = new StatusResponse()
{
ErrorCode = Constants.ErrorCode.CSMBranch003,
Status = Constants.StatusResponse.Failed,
Description = "Fail to save branch:\r\nไม่พบ Channel Code ในฐานข้อมูล CSM"
};
return(response);
}
var branchDataAccess = new BranchDataAccess(_context);
int?upperBranchId = null;
if (!string.IsNullOrEmpty(request.UpperBranchCode))
{
upperBranchId = branchDataAccess.GetBranchIdByBranchCode(request.UpperBranchCode);
if (!upperBranchId.HasValue)
{
response.StatusResponse = new StatusResponse()
{
ErrorCode = Constants.ErrorCode.CSMBranch003,
Status = Constants.StatusResponse.Failed,
Description = "Fail to save branch:\r\nไม่พบ Upper Branch Code ในฐานข้อมูล CSM"
};
return(response);
}
}
#endregion
var result = branchDataAccess.InsertOrUpdateBranch(request, channelId.Value, upperBranchId);
if (result.IsSuccess)
{
response.StatusResponse = new StatusResponse
{
ErrorCode = string.Empty,
Status = Constants.StatusResponse.Success,
Description = "Save successful"
};
AppLog.AuditLog(auditLog, LogStatus.Success, response.StatusResponse.Description);
}
else
{
response.StatusResponse = new StatusResponse
{
ErrorCode = Constants.ErrorCode.CSMBranch003,
Status = Constants.StatusResponse.Failed,
Description = result.ErrorMessage
};
AppLog.AuditLog(auditLog, LogStatus.Fail, response.StatusResponse.Description);
}
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
response.StatusResponse = new StatusResponse
{
ErrorCode = Constants.ErrorCode.CSMBranch004,
Status = Constants.StatusResponse.Failed,
Description = ex.ToString()
};
}
finally
{
Logger.DebugFormat("-- XMLResponse --\n{0}", response.SerializeObject());
stopwatch.Stop();
Logger.DebugFormat("O:--Finish--:ElapsedMilliseconds/{0}", stopwatch.ElapsedMilliseconds);
}
return(response);
}
public InsertOrUpdateUserResponse InsertOrUpdateUser(InsertOrUpdateUserRequest request)
{
var stopwatch = System.Diagnostics.Stopwatch.StartNew();
UserResponse response = new UserResponse();
Logger.Info(_logMsg.Clear().SetPrefixMsg("Call UserService.InsertOrUpdateUser").ToInputLogString());
Logger.Debug("I:--START--:--UserService.InsertOrUpdateUser--");
try
{
if (request.ActionType != 1 && request.ActionType != 2)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "2",
ErrorMessage = "Action Type must be 1 or 2. (1=Insert,2=Update)"
});
}
bool valid = false;
_commonFacade = new CommonFacade();
if (request.Header != null)
{
valid = _commonFacade.VerifyServiceRequest <Header>(request.Header);
response.Header = new Header
{
reference_no = request.Header.reference_no,
service_name = request.Header.service_name,
system_code = request.Header.system_code,
transaction_date = request.Header.transaction_date
};
}
Logger.DebugFormat("-- XMLRequest --\n{0}", request.SerializeObject());
if (!valid)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "99",
ErrorMessage = "Bad Request, the header is not valid"
});
}
#region == Validate Require Field ==
if (string.IsNullOrEmpty(request.WindowsUsername))
{
return(GetReturnErrorRequireField("WindowUserName"));
}
if (string.IsNullOrEmpty(request.EmployeeCodeNew))
{
return(GetReturnErrorRequireField("EmployeeCodeNew"));
}
if (request.ActionType == 2)
{
if (string.IsNullOrEmpty(request.EmployeeCodeOld))
{
return(GetReturnErrorRequireField("EmployeeCodeOld"));
}
}
if (string.IsNullOrEmpty(request.FirstName))
{
return(GetReturnErrorRequireField("FirstName"));
}
if (string.IsNullOrEmpty(request.Phone1) && !request.IsGroup)
{
return(GetReturnErrorRequireField("Phone1", " (Phone1 เป็น Required Field เมื่อ IsGroup = FALSE)"));
}
if (string.IsNullOrEmpty(request.PositionCode))
{
return(GetReturnErrorRequireField("PositionCode"));
}
if (string.IsNullOrEmpty(request.RoleSale))
{
return(GetReturnErrorRequireField("RoleSale"));
}
if (string.IsNullOrEmpty(request.BranchCode))
{
return(GetReturnErrorRequireField("BranchCode"));
}
if (string.IsNullOrEmpty(request.RoleCode))
{
return(GetReturnErrorRequireField("RoleCode"));
}
#endregion
#region == Validate Code ==
_userDataAccess = new UserDataAccess(_context);
int?supervisorUserId = null;
if (!string.IsNullOrEmpty(request.SupervisorEmployeeCode))
{
supervisorUserId = _userDataAccess.GetUserIdByEmployeeCode(request.SupervisorEmployeeCode);
if (!supervisorUserId.HasValue)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "3",
ErrorMessage = "ไม่พบ Employee Code ของ Supervisor ในฐานข้อมูล CSM"
});
}
}
int?roleId = _userDataAccess.GetRoleIdByRoleCode(request.RoleCode);
if (!roleId.HasValue)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "4",
ErrorMessage = "ไม่พบ Role Code ในฐานข้อมูล CSM",
});
}
var branchDataAccess = new BranchDataAccess(_context);
int?branchId = branchDataAccess.GetBranchIdByBranchCode(request.BranchCode);
if (!branchId.HasValue)
{
Logger.DebugFormat("-- XMLResponse --\n{0}", response.SerializeObject());
stopwatch.Stop();
Logger.DebugFormat("O:--Finish--:ElapsedMilliseconds/{0}", stopwatch.ElapsedMilliseconds);
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "5",
ErrorMessage = "ไม่พบ Branch Code ในฐานข้อมูล CSM",
});
}
else
{
response.StatusResponse = new StatusResponse
{
ErrorCode = string.Empty,
Status = Constants.StatusResponse.Success,
Description = "Save successful"
};
Logger.DebugFormat("-- XMLResponse --\n{0}", response.SerializeObject());
stopwatch.Stop();
Logger.DebugFormat("O:--Finish--:ElapsedMilliseconds/{0}", stopwatch.ElapsedMilliseconds);
var result = _userDataAccess.InsertOrUpdateUser(request, supervisorUserId, roleId.Value, branchId.Value);
if (!result.IsSuccess)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "5",
ErrorMessage = result.ErrorMessage
});
}
return(result);
}
#endregion
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "1",
ErrorMessage = ex.Message
});
}
}
public List <BranchEntity> GetBranchByBranchIds(string keyword, List <int> branchIds, int limit)
{
var branchDataAccess = new BranchDataAccess(_context);
return(branchDataAccess.GetBranchByBranchIds(keyword, branchIds, limit));
}
public UpdateCalendarResponse UpdateBranchCalendar(UpdateBranchCalendarRequest request)
{
var stopwatch = System.Diagnostics.Stopwatch.StartNew();
UpdateCalendarResponse response = new UpdateCalendarResponse();
Logger.Info(_logMsg.Clear().SetPrefixMsg("Call BranchService.UpdateBranchCalendar").ToInputLogString());
Logger.Debug("I:--START--:--BranchService.UpdateBranchCalendar--");
try
{
bool valid = false;
_commonFacade = new CommonFacade();
if (request.Header != null)
{
valid = _commonFacade.VerifyServiceRequest <Header>(request.Header);
response.Header = new Header
{
reference_no = request.Header.reference_no,
service_name = request.Header.service_name,
system_code = request.Header.system_code,
transaction_date = request.Header.transaction_date
};
}
Logger.DebugFormat("-- XMLRequest --\n{0}", request.SerializeObject());
var auditLog = new AuditLogEntity();
auditLog.Module = Constants.Module.WebService;
auditLog.Action = Constants.AuditAction.CreateBranch;
auditLog.IpAddress = ApplicationHelpers.GetClientIP();
if (!valid)
{
response.StatusResponse = new StatusResponse()
{
ErrorCode = Constants.ErrorCode.CSMCalendar001,
Status = Constants.StatusResponse.Failed,
Description = "Bad Request, the header is not valid"
};
return(response);
}
else
{
#region == Validate Require Field ==
if (string.IsNullOrEmpty(request.HolidayDesc))
{
response.StatusResponse = new StatusResponse()
{
ErrorCode = Constants.ErrorCode.CSMCalendar002,
Status = Constants.StatusResponse.Failed,
Description = "ข้อมูลที่ส่งมาไม่ครบถ้วน ไม่สามารถบันทึกรายการได้ (Field=HolidateDesc)"
};
return(response);
}
if (request.UpdateMode != 1 && request.UpdateMode != 2)
{
response.StatusResponse = new StatusResponse()
{
ErrorCode = Constants.ErrorCode.CSMCalendar002,
Status = Constants.StatusResponse.Failed,
Description = "ข้อมูลที่ไม่สามารถบันทึกรายการได้ เนื่องจากข้อมูลที่ส่งมาอยู่ในรูปแบบไม่ถูกต้อง (UpdateMode ต้องมีค่า 1 (Delete and Insert) หรือ 2 (Merge) เท่านั้น)"
};
return(response);
}
#endregion
#region == Validate Code ==
var branchDataAccess = new BranchDataAccess(_context);
var branchCodes = request.BranchCodeList;
var branchIds = new List <int>();
if (request.BranchCodeList != null)
{
var branchCodeNotFoundList = new List <string>();
foreach (var code in branchCodes)
{
var branchId = branchDataAccess.GetBranchIdByBranchCode(code);
if (branchId == null)
{
branchCodeNotFoundList.Add(code);
}
else
{
branchIds.Add(branchId.Value);
}
}
//ถ้าlist ของ branch code ที่ไม่มีเบส CSM มากกว่า 0 ให้ส่ง code list กลับไป
if (branchCodeNotFoundList.Count > 0)
{
response.StatusResponse = new StatusResponse()
{
ErrorCode = Constants.ErrorCode.CSMCalendar004,
Status = Constants.StatusResponse.Failed,
BranchCodeNotFoundList = branchCodeNotFoundList,
Description = string.Format(CultureInfo.InvariantCulture, "ข้อมูลที่ไม่สามารถบันทึกรายการได้ เนื่องจากไม่พบ Branch Code ในฐานข้อมูล")
};
return(response);
}
}
else
{
request.BranchCodeList = new List <string>();
}
#endregion
var result = branchDataAccess.UpdateBranchCalendar(request, branchIds);
if (result.IsSuccess)
{
response.StatusResponse = new StatusResponse
{
ErrorCode = string.Empty,
Status = Constants.StatusResponse.Success,
Description = "Save successful"
};
}
else
{
response.StatusResponse = new StatusResponse
{
ErrorCode = Constants.ErrorCode.CSMCalendar003,
Status = Constants.StatusResponse.Failed,
Description = result.ErrorMessage
};
AppLog.AuditLog(auditLog, LogStatus.Fail, response.StatusResponse.Description);
}
}
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
response.StatusResponse = new StatusResponse
{
ErrorCode = Constants.ErrorCode.CSMBranch004,
Status = Constants.StatusResponse.Failed,
Description = ex.ToString()
};
}
finally
{
Logger.DebugFormat("-- XMLResponse --\n{0}", response.SerializeObject());
stopwatch.Stop();
Logger.DebugFormat("O:--Finish--:ElapsedMilliseconds/{0}", stopwatch.ElapsedMilliseconds);
}
return(response);
}
public InsertOrUpdateUserResponse InsertOrUpdateUser(InsertOrUpdateUserRequest request)
{
try
{
if (request.ActionType != 1 && request.ActionType != 2)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "2",
ErrorMessage = "Action Type must be 1 or 2. (1=Insert,2=Update)"
});
}
#region == Validate Require Field ==
if (string.IsNullOrEmpty(request.WindowsUsername))
{
return(GetReturnErrorRequireField("WindowUserName"));
}
if (string.IsNullOrEmpty(request.EmployeeCodeNew))
{
return(GetReturnErrorRequireField("EmployeeCodeNew"));
}
if (request.ActionType == 2)
{
if (string.IsNullOrEmpty(request.EmployeeCodeOld))
{
return(GetReturnErrorRequireField("EmployeeCodeOld"));
}
}
if (string.IsNullOrEmpty(request.FirstName))
{
return(GetReturnErrorRequireField("FirstName"));
}
if (string.IsNullOrEmpty(request.Phone1) && !request.IsGroup)
{
return(GetReturnErrorRequireField("Phone1", " (Phone1 เป็น Required Field เมื่อ IsGroup = FALSE)"));
}
if (string.IsNullOrEmpty(request.PositionCode))
{
return(GetReturnErrorRequireField("PositionCode"));
}
if (string.IsNullOrEmpty(request.RoleSale))
{
return(GetReturnErrorRequireField("RoleSale"));
}
if (string.IsNullOrEmpty(request.BranchCode))
{
return(GetReturnErrorRequireField("BranchCode"));
}
if (string.IsNullOrEmpty(request.RoleCode))
{
return(GetReturnErrorRequireField("RoleCode"));
}
#endregion
#region == Validate Code ==
_userDataAccess = new UserDataAccess(_context);
int?supervisorUserId = null;
if (!string.IsNullOrEmpty(request.SupervisorEmployeeCode))
{
supervisorUserId = _userDataAccess.GetUserIdByEmployeeCode(request.SupervisorEmployeeCode);
if (!supervisorUserId.HasValue)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "3",
ErrorMessage = "ไม่พบ Employee Code ของ Supervisor ในฐานข้อมูล CSM"
});
}
}
int?roleId = _userDataAccess.GetRoleIdByRoleCode(request.RoleCode);
if (!roleId.HasValue)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "4",
ErrorMessage = "ไม่พบ Role Code ในฐานข้อมูล CSM",
});
}
var branchDataAccess = new BranchDataAccess(_context);
int?branchId = branchDataAccess.GetBranchIdByBranchCode(request.BranchCode);
if (!branchId.HasValue)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "5",
ErrorMessage = "ไม่พบ Branch Code ในฐานข้อมูล CSM",
});
}
#endregion
return(_userDataAccess.InsertOrUpdateUser(request, supervisorUserId, roleId.Value, branchId.Value));
}
catch (Exception ex)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "1",
ErrorMessage = ex.Message
});
}
}
public InsertOrUpdateBranchResponse InsertOrUpdateBranch(InsertOrUpdateBranchRequest request)
{
try
{
#region == Validate Require Field ==
if (string.IsNullOrEmpty(request.BranchCode))
{
return(GetReturnErrorRequireField("BranchCode"));
}
if (string.IsNullOrEmpty(request.BranchName))
{
return(GetReturnErrorRequireField("BranchName"));
}
if (string.IsNullOrEmpty(request.ChannelCode))
{
return(GetReturnErrorRequireField("ChannelCode"));
}
if (request.StartTimeHour < 0 || request.StartTimeHour > 23)
{
return(GetReturnErrorInvalidFormat("StartTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 23", "5"));
}
if (request.StartTimeMinute < 0 || request.StartTimeMinute > 59)
{
return(GetReturnErrorInvalidFormat("StartTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 59", "5"));
}
if (request.EndTimeHour < 0 || request.EndTimeHour > 23)
{
return(GetReturnErrorInvalidFormat("EndTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 23", "5"));
}
if (request.EndTimeMinute < 0 || request.EndTimeMinute > 59)
{
return(GetReturnErrorInvalidFormat("EndTimeHour", "ต้องมีค่าระหว่าง 0 ถึง 59", "5"));
}
if (request.Status != 0 && request.Status != 1)
{
return(GetReturnErrorInvalidFormat("Status", "ต้องมีค่าระหว่าง 0 ถึง 1", "5"));
}
#endregion
#region == Validate Code ==
var channelDataAccess = new ChannelDataAccess(_context);
int?channelId = channelDataAccess.GetChannelIdByChannelCode(request.ChannelCode);
if (!channelId.HasValue)
{
return(new InsertOrUpdateBranchResponse()
{
IsSuccess = false,
ErrorCode = "3",
ErrorMessage = "ไม่พบ Channel Code ในฐานข้อมูล CSM",
});
}
var branchDataAccess = new BranchDataAccess(_context);
int?upperBranchId = null;
if (!string.IsNullOrEmpty(request.UpperBranchCode))
{
upperBranchId = branchDataAccess.GetBranchIdByBranchCode(request.UpperBranchCode);
if (!upperBranchId.HasValue)
{
return(new InsertOrUpdateBranchResponse()
{
IsSuccess = false,
ErrorCode = "4",
ErrorMessage = "ไม่พบ Upper Branch Code ในฐานข้อมูล CSM",
});
}
}
#endregion
return(branchDataAccess.InsertOrUpdateBranch(request, channelId.Value, upperBranchId));
}
catch (Exception ex)
{
return(new InsertOrUpdateBranchResponse()
{
IsSuccess = false,
ErrorCode = "1",
ErrorMessage = ex.Message
});
}
}
public UpdateBranchCalendarResponse UpdateBranchCalendar(UpdateBranchCalendarRequest request)
{
try
{
#region == Validate Require Field ==
if (string.IsNullOrEmpty(request.HolidayDesc))
{
return(new UpdateBranchCalendarResponse()
{
IsSuccess = false,
ErrorCode = "2",
ErrorMessage = "ข้อมูลที่ส่งมาไม่ครบถ้วน ไม่สามารถบันทึกรายการได้ (Field=HolidateDesc)"
});
}
if (request.UpdateMode != 1 && request.UpdateMode != 2)
{
return(new UpdateBranchCalendarResponse()
{
IsSuccess = false,
ErrorCode = "3",
ErrorMessage = "ข้อมูลที่ไม่สามารถบันทึกรายการได้ เนื่องจากข้อมูลที่ส่งมาอยู่ในรูปแบบไม่ถูกต้อง (UpdateMode ต้องมีค่า 1 (Delete and Insert) หรือ 2 (Merge) เท่านั้น)"
});
}
#endregion
#region == Validate Code ==
var branchDataAccess = new BranchDataAccess(_context);
var branchCodes = request.BranchCodeList;
var branchIds = new List <int>();
if (request.BranchCodeList != null)
{
foreach (var code in branchCodes)
{
var branchId = branchDataAccess.GetBranchIdByBranchCode(code);
if (branchId == null)
{
return(new UpdateBranchCalendarResponse
{
IsSuccess = false,
ErrorCode = "4",
ErrorMessage = string.Format(CultureInfo.InvariantCulture, "ข้อมูลที่ไม่สามารถบันทึกรายการได้ เนื่องจากไม่พบ Branch Code ในฐานข้อมูล (Code={0})", code),
});
}
branchIds.Add(branchId.Value);
}
}
else
{
request.BranchCodeList = new List <string>();
}
#endregion
return(branchDataAccess.UpdateBranchCalendar(request, branchIds));
}
catch (Exception ex)
{
return(new UpdateBranchCalendarResponse()
{
IsSuccess = false,
ErrorCode = "1",
ErrorMessage = ex.Message
});
}
}
