private void InsertOrUpdateUserPhone(List <TB_R_USER_PHONE> dbPhoneList, string phoneNo, int order, TB_R_USER user, DateTime transactionDateTime)
{
var dbPhone = dbPhoneList.FirstOrDefault(x => x.ORDER == order);
if (dbPhone == null)
{
// Insert
dbPhone = new TB_R_USER_PHONE();
dbPhone.TB_R_USER = user;
dbPhone.PHONE_NO = phoneNo;
dbPhone.ORDER = Convert.ToInt16(order);
dbPhone.CREATE_DATE = transactionDateTime;
dbPhone.UPDATE_DATE = transactionDateTime;
_context.TB_R_USER_PHONE.Add(dbPhone);
}
else
{
// Update
if (phoneNo != dbPhone.PHONE_NO)
{
dbPhone.PHONE_NO = phoneNo;
dbPhone.UPDATE_DATE = transactionDateTime;
}
SetEntryStateModified(dbPhone);
}
}
public InsertOrUpdateUserResponse InsertOrUpdateUser(InsertOrUpdateUserRequest request, int?supervisorUserId, int roleId, int branchId)
{
_context.Configuration.AutoDetectChangesEnabled = false;
try
{
var result = new InsertOrUpdateUserResponse();
TB_R_USER dbUser = null;
var transactionDateTime = DateTime.Now;
//if (request.ActionType == 1)
//{
// // Insert
// dbUser = null;
//}
//else
//{
// // Update
// dbUser = _context.TB_R_USER.Where(user => user.EMPLOYEE_CODE.Trim().ToUpper() == request.EmployeeCodeOld.Trim().ToUpper()).FirstOrDefault();
// if (dbUser == null)
// {
// result.IsSuccess = false;
// result.ErrorCode = "8";
// result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูล User เนื่องจากไม่พบข้อมูล User (Employee Code Old='" + request.EmployeeCodeOld + "')";
// return result;
// }
//}
if (!string.IsNullOrEmpty(request.EmployeeCodeOld))
{
dbUser = _context.TB_R_USER.Where(user => user.EMPLOYEE_CODE.Trim().ToUpper() == request.EmployeeCodeOld.Trim().ToUpper()).FirstOrDefault();
}
if (dbUser == null)
{
dbUser = new TB_R_USER();
result.IsNewUser = true;
}
else
{
result.IsNewUser = false;
// IF (Change Branch) Or (Change Status 1 to 0)
if (dbUser.BRANCH_ID != branchId || (dbUser.STATUS == 1 && request.Status == 0))
{
#region == Validate Job On Hand ==
var userId = dbUser.USER_ID;
var activeStatuses = new int[]
{
Constants.SRStatusId.Open,
Constants.SRStatusId.InProgress,
Constants.SRStatusId.WaitingCustomer,
Constants.SRStatusId.RouteBack,
};
var countJobOnHand = _context.TB_T_SR.Count(sr =>
(
(sr.OWNER_USER_ID == userId || sr.DELEGATE_USER_ID == userId) &&
activeStatuses.Contains(sr.SR_STATUS_ID.Value)
)
||
(
sr.CREATE_USER == userId &&
sr.SR_STATUS_ID == Constants.SRStatusId.Draft
)
);
if (countJobOnHand > 0)
{
result.IsSuccess = false;
result.ErrorCode = "7";
result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูล User ได้เนื่องจากมีงานค้างในมือ (ServiceRequest)";
return(result);
}
#endregion
}
}
var actionUser = _context.TB_R_USER.Where(user => user.USERNAME.Trim().ToUpper() == request.ActionUsername.Trim().ToUpper()).FirstOrDefault();
if (actionUser == null)
{
//if (dbUser == null)
//{
// result.IsSuccess = false;
// result.ErrorCode = "9";
// result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูล User เนื่องจากไม่พบข้อมูล Action User (Action Username='******')";
// return result;
//}
actionUser = _context.TB_R_USER.Where(user => user.USERNAME.Trim().ToUpper() == Constants.SystemUserName).FirstOrDefault();
}
dbUser.BRANCH_ID = branchId;
dbUser.SUPERVISOR_ID = supervisorUserId;
dbUser.FIRST_NAME = ValueOrDefault(request.FirstName);
dbUser.LAST_NAME = ValueOrDefault(request.LastName);
dbUser.USERNAME = ValueOrDefault(request.WindowsUsername);
dbUser.STATUS = Convert.ToInt16(request.Status);
dbUser.ROLE_ID = roleId;
dbUser.EMPLOYEE_CODE = ValueOrDefault(request.EmployeeCodeNew);
dbUser.UPDATE_DATE = transactionDateTime;
dbUser.IS_GROUP = request.IsGroup;
dbUser.POSITION_CODE = ValueOrDefault(request.PositionCode);
dbUser.MARKETING_CODE = ValueOrDefault(request.MarketingCode);
dbUser.EMAIL = ValueOrDefault(request.Email);
dbUser.ROLE_SALE = ValueOrDefault(request.RoleSale);
dbUser.MARKETING_TEAM = ValueOrDefault(request.MarketingTeam);
dbUser.LINE = ValueOrDefault(request.Line);
dbUser.RANK = ValueOrDefault(request.Rank);
dbUser.EMPLOYEE_TYPE = ValueOrDefault(request.EmployeeType);
dbUser.COMPANY_NAME = ValueOrDefault(request.CompanyName);
dbUser.TELESALE_TEAM = ValueOrDefault(request.TelesaleTeam);
dbUser.MARKETING_FLAG = request.MarketingFlag;
dbUser.EXPORT_DATE = null;
if (result.IsNewUser)
{
for (var i = 0; i < 3; i++)
{
var phone = new TB_R_USER_PHONE();
phone.TB_R_USER = dbUser;
phone.PHONE_NO = i == 0 ? request.Phone1 : i == 1 ? request.Phone2 : request.Phone3;
phone.ORDER = Convert.ToInt16(i + 1);
phone.CREATE_DATE = transactionDateTime;
phone.UPDATE_DATE = transactionDateTime;
_context.TB_R_USER_PHONE.Add(phone);
}
}
else
{
var dbPhoneList = dbUser.TB_R_USER_PHONE.OrderBy(p => p.ORDER).Take(10).ToList();
InsertOrUpdateUserPhone(dbPhoneList, request.Phone1, 1, dbUser, transactionDateTime);
InsertOrUpdateUserPhone(dbPhoneList, request.Phone2, 2, dbUser, transactionDateTime);
InsertOrUpdateUserPhone(dbPhoneList, request.Phone3, 3, dbUser, transactionDateTime);
}
if (result.IsNewUser)
{
dbUser.CREATE_USERNAME = ValueOrDefault(request.ActionUsername);
dbUser.UPDATE_USERNAME = ValueOrDefault(request.ActionUsername);
dbUser.CREATE_DATE = transactionDateTime;
dbUser.UPDATE_DATE = transactionDateTime;
_context.TB_R_USER.Add(dbUser);
}
else
{
dbUser.UPDATE_USERNAME = ValueOrDefault(request.ActionUsername);
dbUser.UPDATE_DATE = transactionDateTime;
SetEntryStateModified(dbUser);
}
this.Save();
if (!request.IsGroup)
{
var _customerDataAccess = new CustomerDataAccess(_context);
CustomerEntity customerEntity;
bool isCreateCustomer;
if (result.IsNewUser)
{
isCreateCustomer = true;
customerEntity = new CustomerEntity();
}
else
{
customerEntity = _customerDataAccess.GetCustomerByEmployeeID(dbUser.USER_ID);
// If Update but no have Customer for this user >> It will create
if (customerEntity == null)
{
customerEntity = new CustomerEntity();
isCreateCustomer = true;
}
else
{
isCreateCustomer = false;
}
}
// Create/Update Customer for this user
if (isCreateCustomer)
{
// Create Customer
var _commonDataAccess = new CommonDataAccess(_context);
var subscriptionType = _commonDataAccess.GetSubscriptTypeByCode(Constants.DefaultSubscriptionTypeForUser);
customerEntity.CustomerType = Constants.CustomerType.Employee;
customerEntity.FirstNameThai = request.FirstName;
customerEntity.LastNameThai = request.LastName;
customerEntity.SubscriptType = subscriptionType;
customerEntity.CardNo = request.EmployeeCodeNew;
customerEntity.Email = request.Email;
customerEntity.EmployeeId = dbUser.USER_ID;
customerEntity.TitleThai = new TitleEntity();
customerEntity.TitleEnglish = new TitleEntity();
customerEntity.CreateUser = new UserEntity()
{
UserId = actionUser.USER_ID
};
customerEntity.UpdateUser = new UserEntity()
{
UserId = actionUser.USER_ID
};
customerEntity.PhoneList = new List <PhoneEntity>();
if (!string.IsNullOrEmpty(request.Phone1))
{
customerEntity.PhoneList.Add(new PhoneEntity()
{
PhoneNo = request.Phone1
});
}
if (!string.IsNullOrEmpty(request.Phone2))
{
customerEntity.PhoneList.Add(new PhoneEntity()
{
PhoneNo = request.Phone2
});
}
if (!string.IsNullOrEmpty(request.Phone3))
{
customerEntity.PhoneList.Add(new PhoneEntity()
{
PhoneNo = request.Phone3
});
}
var isSaveCustomerSuccess = _customerDataAccess.SaveCustomer(customerEntity);
if (!isSaveCustomerSuccess)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "6",
ErrorMessage = "Cannot create customer for this user.",
});
}
}
else
{
customerEntity.FirstNameThai = request.FirstName;
customerEntity.LastNameThai = request.LastName;
customerEntity.CardNo = request.EmployeeCodeNew;
customerEntity.Email = request.Email;
customerEntity.TitleThai = new TitleEntity();
customerEntity.TitleEnglish = new TitleEntity();
customerEntity.CreateUser = new UserEntity()
{
UserId = actionUser.USER_ID
};
customerEntity.UpdateUser = new UserEntity()
{
UserId = actionUser.USER_ID
};
if (customerEntity.PhoneList == null)
{
customerEntity.PhoneList = new List <PhoneEntity>();
}
var phones = new List <string>();
if (!string.IsNullOrEmpty(request.Phone1))
{
phones.Add(request.Phone1);
}
if (!string.IsNullOrEmpty(request.Phone2))
{
phones.Add(request.Phone2);
}
if (!string.IsNullOrEmpty(request.Phone3))
{
phones.Add(request.Phone3);
}
if (phones.Count > customerEntity.PhoneList.Count)
{
var diff = (phones.Count - customerEntity.PhoneList.Count);
for (int i = 0; i < diff; i++)
{
customerEntity.PhoneList.Add(new PhoneEntity());
}
}
else if (phones.Count < customerEntity.PhoneList.Count)
{
var diff = (customerEntity.PhoneList.Count - phones.Count);
for (int i = 0; i < diff; i++)
{
customerEntity.PhoneList.RemoveAt(customerEntity.PhoneList.Count - 1);
}
}
for (int i = 0; i < phones.Count; i++)
{
customerEntity.PhoneList[i].PhoneNo = phones[i];
}
var isSaveCustomerSuccess = _customerDataAccess.SaveCustomer(customerEntity);
if (!isSaveCustomerSuccess)
{
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "6",
ErrorMessage = "Cannot update customer for this user.",
});
}
}
}
result.IsSuccess = true;
return(result);
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
return(new InsertOrUpdateUserResponse()
{
IsSuccess = false,
ErrorCode = "1",
ErrorMessage = ex.Message,
});
}
finally
{
_context.Configuration.AutoDetectChangesEnabled = false;
}
}