private StaffDataManagement GetSearchCondition()
{
StaffDataManagement data = new StaffDataManagement();
data.Username = txtUsernameSearch.Text.Trim();
data.BranchCode = cmbBranchSearch.Items.Count > 0 ? cmbBranchSearch.SelectedItem.Value : string.Empty;
data.EmpCode = txtEmpCodeSearch.Text.Trim();
data.MarketingCode = txtMarketingCodeSearch.Text.Trim();
data.StaffNameTH = txtStaffNameTHSearch.Text.Trim();
data.PositionId = cmbPositionSearch.SelectedItem.Value;
data.Team = txtTeamSearch.Text.Trim();
if (cmbStaffTypeSearch.Items.Count > 0 && cmbStaffTypeSearch.SelectedItem.Value != string.Empty)
{
data.StaffTypeId = decimal.Parse(cmbStaffTypeSearch.SelectedItem.Value);
}
if (cmbDepartmentSearch.Items.Count > 0 && cmbDepartmentSearch.SelectedItem.Value != string.Empty)
{
data.DepartmentId = int.Parse(cmbDepartmentSearch.SelectedItem.Value);
}
if (cmbCOCTeamSearch.Items.Count > 0 && cmbCOCTeamSearch.SelectedItem.Value != string.Empty)
{
data.CocTeam = cmbCOCTeamSearch.SelectedItem.Value;
}
data.PageIndex = pcTop.SelectedPageIndex;
return(data);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateData())
{
StaffDataManagement data = new StaffDataManagement();
data.Username = txtUserName.Text.Trim();
data.EmpCode = txtEmpCode.Text.Trim();
data.MarketingCode = txtMarketingCode.Text.Trim();
data.StaffNameTH = txtStaffNameTH.Text.Trim();
data.TelNo = txtTellNo.Text.Trim();
data.StaffEmail = txtStaffEmail.Text.Trim();
data.PositionId = cmbPosition.SelectedItem.Value;
data.StaffTypeId = decimal.Parse(cmbStaffType.SelectedItem.Value);
data.Team = txtTeam.Text.Trim();
data.BranchCode = cmbBranchCode.SelectedItem.Value;
if (cmbHeadStaffId.Items.Count > 0)
{
if (!string.IsNullOrEmpty(cmbHeadStaffId.SelectedItem.Value))
{
data.HeadStaffId = int.Parse(cmbHeadStaffId.SelectedItem.Value);
}
}
if (cmbDepartment.Items.Count > 0)
{
if (!string.IsNullOrEmpty(cmbDepartment.SelectedItem.Value))
{
data.DepartmentId = int.Parse(cmbDepartment.SelectedItem.Value);
}
}
if (cmbCocTeam.Items.Count > 0)
{
if (!string.IsNullOrEmpty(cmbCocTeam.SelectedItem.Value))
{
data.CocTeam = cmbCocTeam.SelectedItem.Value;
}
}
string staffId = StaffBiz.InsertStaff(data, HttpContext.Current.User.Identity.Name);
Session[coc_staffid] = staffId;
AppUtil.ClientAlertAndRedirect(Page, "บันทึกข้อมูลเจ้าหน้าที่สำเร็จ", "COC_SCR_007.aspx");
}
else
{
AppUtil.ClientAlert(Page, "กรุณาระบุข้อมูลให้ครบถ้วน");
}
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
_log.Debug(message);
AppUtil.ClientAlert(Page, message);
}
}
public string UpdateStaff(StaffDataManagement data, string username, int flag)
{
var staff = slmdb.kkslm_ms_staff.Where(p => p.slm_StaffId == data.StaffId).FirstOrDefault();
if (staff != null)
{
try
{
staff.slm_UserName = data.Username;
staff.slm_EmpCode = data.EmpCode;
staff.slm_MarketingCode = data.MarketingCode;
staff.slm_StaffNameTH = data.StaffNameTH;
staff.slm_TellNo = data.TelNo;
staff.slm_StaffEmail = data.StaffEmail;
staff.slm_Position_id = data.PositionId;
staff.slm_Team = data.Team;
if (data.StaffTypeId != null)
{
staff.slm_StaffTypeId = data.StaffTypeId.Value;
}
if (!string.IsNullOrEmpty(data.BranchCode))
{
staff.slm_BranchCode = data.BranchCode;
}
staff.slm_DepartmentId = data.DepartmentId;
staff.slm_HeadStaffId = data.HeadStaffId;
staff.slm_UpdatedBy = username;
staff.slm_UpdatedDate = DateTime.Now;
staff.is_Deleted = data.Is_Deleted.Value;
if (flag == 1)
{
staff.slm_UpdateStatusDate = DateTime.Now;
staff.slm_UpdateStatusBy = username;
}
slmdb.SaveChanges();
return(data.StaffId.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
else
{
return(data.StaffId.ToString());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateData())
{
StaffDataManagement data = new StaffDataManagement();
data.Username = txtUserName.Text.Trim();
data.UserType = rbnUserTypeIndividual.Checked ? "I" : "G";
data.EmpCode = txtEmpCode.Text.Trim();
data.MarketingCode = txtMarketingCode.Text.Trim();
data.IsMarketing = chkMarketing.Checked;
data.StaffNameTH = txtStaffNameTH.Text.Trim();
data.TelNo = txtTellNo.Text.Trim();
data.TelNo2 = txtTellNo2.Text.Trim();
data.TelNo3 = txtTellNo3.Text.Trim();
data.StaffEmail = txtStaffEmail.Text.Trim();
data.PositionId = int.Parse(cmbPosition.SelectedItem.Value);
data.StaffTypeId = decimal.Parse(cmbStaffType.SelectedItem.Value);
data.RoleServiceId = int.Parse(cmbRoleService.SelectedItem.Value);
data.Team = txtTeam.Text.Trim();
data.BranchCode = cmbBranchCode.SelectedItem.Value;
data.Level = AppUtil.SafeInt(cmbLevel.SelectedItem.Value);
data.Category = AppUtil.SafeInt(cmbCategory.SelectedItem.Value);
data.Host = AppUtil.SafeInt(cmbHost.SelectedItem.Value);
data.TeamTelesale = AppUtil.SafeInt(cmbTeamTelesale.SelectedItem.Value);
//data.InternalPhone = txtInternalPhone.Text;
//check if user = individual telno1 must not null
if (data.UserType == "I")
{
if (string.IsNullOrEmpty(data.TelNo))
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ #1");
return;
}
}
//telphone must not duplicate
if (!string.IsNullOrEmpty(data.TelNo) && !string.IsNullOrEmpty(data.TelNo2))
{
if (data.TelNo == data.TelNo2)
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ ไม่ซ้ำกัน");
return;
}
}
if (!string.IsNullOrEmpty(data.TelNo) && !string.IsNullOrEmpty(data.TelNo3))
{
if (data.TelNo == data.TelNo3)
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ ไม่ซ้ำกัน");
return;
}
}
if (!string.IsNullOrEmpty(data.TelNo2) && !string.IsNullOrEmpty(data.TelNo3))
{
if (data.TelNo2 == data.TelNo3)
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ ไม่ซ้ำกัน");
return;
}
}
if (cmbHeadStaffId.Items.Count > 0 && !string.IsNullOrEmpty(cmbHeadStaffId.SelectedItem.Value))
{
data.HeadStaffId = int.Parse(cmbHeadStaffId.SelectedItem.Value);
}
if (cmbDepartment.Items.Count > 0)
{
if (!string.IsNullOrEmpty(cmbDepartment.SelectedItem.Value))
{
data.DepartmentId = int.Parse(cmbDepartment.SelectedItem.Value);
}
}
var username = HttpContext.Current.User.Identity.Name;
if (AppConstant.CSMServiceEnableSyncUser)
{
try
{
var response = CSMService.InsertOrUpdateUser(1, data, username);
if (!response.IsSuccess)
{
//AppUtil.ClientAlert(Page, "การบันทึกข้อมูลไม่สำเร็จที่ ระบบ CSM");
AppUtil.ClientAlert(Page, !string.IsNullOrEmpty(response.ErrorMessage) ? response.ErrorMessage : "การบันทึกข้อมูลไม่สำเร็จที่ ระบบ CSM");
return;
}
}
catch
{
AppUtil.ClientAlert(Page, "การบันทึกข้อมูลไม่สำเร็จเนื่องจากไม่สามารถเชื่อมต่อระบบ CSM");
return;
}
}
string staffId = SlmScr019Biz.InsertStaff(data, username);
Session[ss_staffid] = staffId;
AppUtil.ClientAlertAndRedirect(Page, "บันทึกข้อมูลเจ้าหน้าที่สำเร็จ", "SLM_SCR_018.aspx");
}
else
{
AppUtil.ClientAlert(Page, "กรุณาระบุข้อมูลให้ครบถ้วน");
}
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
_log.Error(message);
AppUtil.ClientAlert(Page, message);
}
}
private void SetSerachCondition(StaffDataManagement conn)
{
bool dosearch = false;
try
{
if (!string.IsNullOrEmpty(conn.Username))
{
txtUsernameSearch.Text = conn.Username;
dosearch = true;
}
if (!string.IsNullOrEmpty(conn.BranchCode))
{
cmbBranchSearch.SelectedIndex = cmbBranchSearch.Items.IndexOf(cmbBranchSearch.Items.FindByValue(conn.BranchCode));
dosearch = true;
}
if (!string.IsNullOrEmpty(conn.EmpCode))
{
txtEmpCodeSearch.Text = conn.EmpCode;
dosearch = true;
}
if (!string.IsNullOrEmpty(conn.MarketingCode))
{
txtMarketingCodeSearch.Text = conn.MarketingCode;
dosearch = true;
}
if (!string.IsNullOrEmpty(conn.StaffNameTH))
{
txtStaffNameTHSearch.Text = conn.StaffNameTH;
dosearch = true;
}
if (!string.IsNullOrEmpty(conn.PositionId))
{
cmbPositionSearch.SelectedIndex = cmbPositionSearch.Items.IndexOf(cmbPositionSearch.Items.FindByValue(conn.PositionId));
dosearch = true;
}
if (conn.StaffTypeId != null)
{
cmbStaffTypeSearch.SelectedIndex = cmbStaffTypeSearch.Items.IndexOf(cmbStaffTypeSearch.Items.FindByValue(conn.StaffTypeId.Value.ToString()));
dosearch = true;
}
if (!string.IsNullOrEmpty(conn.Team))
{
txtTeamSearch.Text = conn.Team;
dosearch = true;
}
if (conn.DepartmentId != null)
{
cmbDepartmentSearch.SelectedIndex = cmbDepartmentSearch.Items.IndexOf(cmbDepartmentSearch.Items.FindByValue(conn.DepartmentId.Value.ToString()));
dosearch = true;
}
if (conn.CocTeam != null)
{
cmbCOCTeamSearch.SelectedIndex = cmbCOCTeamSearch.Items.IndexOf(cmbCOCTeamSearch.Items.FindByValue(conn.CocTeam));
dosearch = true;
}
if (dosearch)
{
DoSearchData(conn.PageIndex != null ? conn.PageIndex.Value : 0);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
StaffDataManagement staff = new StaffDataManagement();
if (txtEmpCodePopup.Text.Trim() != "")
{
//staff = SlmScr018Biz.GetStaffDataByEmpcode(txtEmpCodePopup.Text.Trim(), SetDept());
staff = SlmScr018Biz.GetStaffDataByEmpcode(txtEmpCodePopup.Text.Trim(), "");
if (staff != null)
{
txtStaffId.Text = staff.StaffId.ToString();
//txtEmpCodePopup.Text = staff.EmpCode;
txtUsernamePopup.Text = staff.Username;
txtMarketingCode.Text = staff.MarketingCode;
txtStaffNameTH.Text = staff.StaffNameTH;
txtTellNo.Text = staff.TelNo;
txtStaffEmail.Text = staff.StaffEmail;
if (!string.IsNullOrEmpty(staff.UserType))
{
if (staff.UserType.ToUpper() == "I")
{
rbnUserTypeIndividual.Checked = true;
rbnUserTypeGroup.Checked = false;
}
else if (staff.UserType.ToUpper() == "G")
{
rbnUserTypeGroup.Checked = true;
rbnUserTypeIndividual.Checked = false;
}
else if (staff.UserType == null)
{
rbnUserTypeIndividual.Checked = false;
rbnUserTypeGroup.Checked = false;
}
rbnUserTypeIndividual.Enabled = false;
rbnUserTypeGroup.Enabled = false;
}
if (staff.PositionId != null)
{
cmbPosition.SelectedIndex = cmbPosition.Items.IndexOf(cmbPosition.Items.FindByValue(staff.PositionId.ToString()));
}
if (staff.StaffTypeId != null)
{
cmbStaffType.SelectedIndex = cmbStaffType.Items.IndexOf(cmbStaffType.Items.FindByValue(staff.StaffTypeId.ToString()));
}
txtTeam.Text = staff.Team;
cmbBranchCode.SelectedIndex = cmbBranchCode.Items.IndexOf(cmbBranchCode.Items.FindByValue(staff.BranchCode));
if (staff.HeadStaffId != null)
{
string branchCode = StaffBiz.GetBranchCode(staff.HeadStaffId.Value);
if (!string.IsNullOrEmpty(branchCode))
{
ListItem item = cmbHeadBranchCode.Items.FindByValue(branchCode);
if (item != null)
{
cmbHeadBranchCode.SelectedIndex = cmbHeadBranchCode.Items.IndexOf(item);
}
else
{
//Branch ที่ถูกปิด
string branchName = BranchBiz.GetBranchName(branchCode);
if (!string.IsNullOrEmpty(branchName))
{
cmbHeadBranchCode.Items.Insert(1, new ListItem(branchName, branchCode));
cmbHeadBranchCode.SelectedIndex = 1;
}
}
}
cmbHeadBranchCode_SelectedIndexChanged();
cmbHeadStaffId.SelectedIndex = cmbHeadStaffId.Items.IndexOf(cmbHeadStaffId.Items.FindByValue(staff.HeadStaffId.ToString()));
}
if (staff.DepartmentId != null)
{
cmbDepartment.SelectedIndex = cmbDepartment.Items.IndexOf(cmbDepartment.Items.FindByValue(staff.DepartmentId.ToString()));
}
else
{
cmbDepartment.SelectedIndex = -1;
}
if (staff.Is_Deleted != null)
{
if (staff.Is_Deleted == 0)
{
rdNormal.Checked = true;
}
else if (staff.Is_Deleted == 1)
{
rdRetire.Checked = true;
}
else
{
rdNormal.Checked = false;
rdRetire.Checked = false;
}
}
}
else
{
txtStaffId.Text = "";
txtUsernamePopup.Text = "";
txtMarketingCode.Text = "";
txtStaffNameTH.Text = "";
txtTellNo.Text = "";
txtStaffEmail.Text = "";
cmbPosition.SelectedIndex = -1;
cmbStaffType.SelectedIndex = -1;
txtTeam.Text = "";
cmbBranchCode.SelectedIndex = -1;
cmbHeadBranchCode.SelectedIndex = -1;
cmbHeadBranchCode_SelectedIndexChanged();
cmbHeadStaffId.SelectedIndex = -1;
cmbDepartment.SelectedIndex = -1;
rdNormal.Checked = false;
rdRetire.Checked = false;
rbnUserTypeIndividual.Checked = false;
rbnUserTypeGroup.Checked = false;
rbnUserTypeIndividual.Enabled = false;
rbnUserTypeGroup.Enabled = false;
AppUtil.ClientAlert(Page, "ไม่พบข้อมูลพนักงานเจ้าหน้าที่");
}
}
else
{
AppUtil.ClientAlert(Page, "กรุณาระบุรหัสพนักงานธนาคาร");
}
upPopup.Update();
mpePopupTransfer.Show();
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
AppUtil.ClientAlert(Page, message);
mpePopupTransfer.Show();
}
}
public static InsertOrUpdateUserResponse InsertOrUpdateUser(int actionType, StaffDataManagement data, string username)
{
_log.Info("===== [Start] Call WS Submit Staff Data to CSM: InsertOrUpdateUser =====");
InsertOrUpdateUserRequest request = new InsertOrUpdateUserRequest();
request.Header = new WebServiceHeader();
request.Header.service_name = AppConstant.GetCSMServiceName;
request.Header.user_name = AppConstant.GetCSMUsername;
request.Header.system_code = AppConstant.GetCSMSystemCode;
request.Header.password = AppConstant.GetCSMPassword;
request.Header.command = "InsertOrUpdateUser";
request.ActionType = actionType;
request.WindowsUsername = data.Username;
request.EmployeeCodeNew = data.EmpCode;
if (actionType == 2)
{
request.EmployeeCodeOld = data.EmpCodeOld;
}
if (!string.IsNullOrEmpty(data.StaffNameTH))
{
var index = data.StaffNameTH.IndexOf(" ");
if (index != -1)
{
request.FirstName = data.StaffNameTH.Substring(0, index).Trim();
request.LastName = data.StaffNameTH.Substring(index, data.StaffNameTH.Length - index).Trim();
}
else
{
request.FirstName = data.StaffNameTH;
request.LastName = string.Empty;
}
}
if (data.HeadStaffId.HasValue)
{
var headStaffEmployeeCode = SlmScr019Biz.GetStaffEmployeeCode(data.HeadStaffId.Value);
request.SupervisorEmployeeCode = headStaffEmployeeCode;
}
if (!string.IsNullOrEmpty(data.UserType))
{
request.IsGroup = data.UserType.ToUpper() == "G";
}
request.Phone1 = data.TelNo;
request.Phone2 = data.TelNo2;
request.Phone3 = data.TelNo3;
if (data.StaffTypeId.HasValue)
{
var staffTypeDesc = SlmScr019Biz.GetStaffTypeDesc(data.StaffTypeId.Value);
request.RoleSale = staffTypeDesc;
}
//request.BranchCode = data.BranchCode;
//get branchCodeNew for CSM
request.BranchCode = SlmScr019Biz.GetBranchCodeNew(data.BranchCode);
if (data.RoleServiceId.HasValue)
{
var roleServiceCode = SlmScr019Biz.GetRoleServiceCode(data.RoleServiceId.Value);
request.RoleCode = roleServiceCode;
}
request.Status = (data.Is_Deleted ?? 0) == 0 ? 1 : 0;
if (data.PositionId.HasValue)
{
var positionNameAbb = SlmScr019Biz.GetPositionNameAbb(data.PositionId.Value);
request.PositionCode = positionNameAbb;
}
request.MarketingCode = data.MarketingCode;
request.MarketingFlag = data.IsMarketing;
request.Email = data.StaffEmail;
request.MarketingTeam = data.Team;
if (data.DepartmentId.HasValue)
{
var departmentName = SlmScr019Biz.GetDepartmentName(data.DepartmentId.Value);
request.Line = departmentName;
}
if (data.Level.HasValue)
{
var levelName = SlmScr019Biz.GetLevelName(data.Level.Value);
request.Rank = levelName;
}
if (data.Category.HasValue)
{
var categoryName = SlmScr019Biz.GetCategoryName(data.Category.Value);
request.EmployeeType = categoryName;
}
if (data.Host.HasValue)
{
var hostName = SlmScr019Biz.GetHostName(data.Host.Value);
request.CompanyName = hostName;
}
if (data.TeamTelesale.HasValue)
{
var teamTelesaleName = SlmScr019Biz.GetTeamTelesaleName(data.TeamTelesale.Value);
request.TelesaleTeam = teamTelesaleName;
}
request.ActionUsername = username;
LogRequest_InsertOrUpdateUser(request);
try
{
var start = DateTime.Now;
_log.DebugFormat("Start Call InsertOrUpdateUser at {0:dd/MM/yyyy HH:mm:ss}", start);
CSMUserServiceClient client = new CSMUserServiceClient();
var response = client.InsertOrUpdateUser(request);
var stop = DateTime.Now;
_log.DebugFormat("End Call InsertOrUpdateUser at {0:dd/MM/yyyy HH:mm:ss} (Elapsed Time={1} seconds)", stop, stop.Subtract(start).TotalSeconds);
if (response.IsSuccess)
{
_log.Info("===== [End] Call WS Submit Staff Data to CSM: InsertOrUpdateUser (SUCCESS) =====");
_log.Debug("===== [START] Response Data =====");
_log.Debug("IsSuccess=" + response.IsSuccess);
_log.Debug("IsNewUser="******"ErrorCode=" + response.ErrorCode);
_log.Debug("ErrorMessage=" + response.ErrorMessage);
_log.Debug("===== [END] Response Data =====");
}
else
{
_log.Error("===== [End] Call WS Submit Staff Data to CSM: InsertOrUpdateUser (FAIL) =====");
_log.Error("===== [START] Response Data =====");
_log.Error("IsSuccess=" + response.IsSuccess);
_log.Error("ErrorCode=" + response.ErrorCode);
_log.Error("ErrorMessage=" + response.ErrorMessage);
_log.Error("===== [END] Response Data =====");
}
//LogResponse_InsertOrUpdateUser(response);
return(response);
}
catch (Exception ex)
{
_log.Error("===== [End] Call WS Submit Staff Data to CSM: InsertOrUpdateUser (FAIL with Exception) =====", ex);
throw;
}
}
public string InsertStaff(StaffDataManagement data, string username)
{
try
{
kkslm_ms_staff staff = new kkslm_ms_staff();
staff.slm_UserName = data.Username;
staff.slm_EmpCode = data.EmpCode;
if (!string.IsNullOrEmpty(data.MarketingCode))
{
staff.slm_MarketingCode = data.MarketingCode;
}
staff.slm_StaffNameTH = data.StaffNameTH;
if (!string.IsNullOrEmpty(data.TelNo))
{
staff.slm_TellNo = data.TelNo;
}
staff.slm_StaffEmail = data.StaffEmail;
staff.slm_Position_id = data.PositionId;
if (!string.IsNullOrEmpty(data.Team))
{
staff.slm_Team = data.Team;
}
if (data.StaffTypeId != null)
{
staff.slm_StaffTypeId = data.StaffTypeId.Value;
}
if (!string.IsNullOrEmpty(data.BranchCode))
{
staff.slm_BranchCode = data.BranchCode;
}
if (data.HeadStaffId != null)
{
staff.slm_HeadStaffId = data.HeadStaffId.Value;
}
if (data.DepartmentId != null)
{
staff.slm_DepartmentId = data.DepartmentId.Value;
}
staff.slm_CreatedBy = username;
staff.slm_CreatedDate = DateTime.Now;
staff.is_Deleted = 0;
staff.slm_IsActive = 0;
staff.slm_IsLocked = 0;
staff.slm_UpdateStatusDate = DateTime.Now;
staff.slm_UpdateStatusBy = username;
slmdb.kkslm_ms_staff.AddObject(staff);
slmdb.SaveChanges();
return(staff.slm_StaffId.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadStaffData()
{
try
{
StaffDataManagement staff = new StaffDataManagement();
if (txtStaffId.Text.Trim() != "")
{
staff = SlmScr018Biz.GetStaffData(int.Parse(txtStaffId.Text.Trim()));
}
if (staff != null)
{
txtUsername.Text = staff.Username;
lblUsername.Text = staff.Username;
if (!string.IsNullOrEmpty(staff.UserType))
{
if (staff.UserType.ToUpper() == "I")
{
rbnUserTypeIndividual.Checked = true;
}
else if (staff.UserType.ToUpper() == "G")
{
rbnUserTypeGroup.Checked = true;
}
}
rbnUserTypeIndividual.Enabled = false;
rbnUserTypeGroup.Enabled = false;
txtEmpCode.Text = staff.EmpCode;
txtEmpCodeOld.Value = staff.EmpCode;
txtMarketingCode.Text = staff.MarketingCode;
chkMarketing.Checked = staff.IsMarketing;
txtStaffNameTH.Text = staff.StaffNameTH;
txtTellNo.Text = staff.TelNo;
txtTellNo2.Text = staff.TelNo2;
txtTellNo3.Text = staff.TelNo3;
txtStaffEmail.Text = staff.StaffEmail;
//txtInternalPhone.Text = staff.InternalPhone;
if (staff.PositionId != null)
{
cmbPosition.SelectedIndex = cmbPosition.Items.IndexOf(cmbPosition.Items.FindByValue(staff.PositionId.ToString()));
}
if (staff.StaffTypeId != null)
{
cmbStaffType.SelectedIndex = cmbStaffType.Items.IndexOf(cmbStaffType.Items.FindByValue(staff.StaffTypeId.ToString()));
}
if (staff.RoleServiceId != null)
{
cmbRoleService.SelectedIndex = cmbRoleService.Items.IndexOf(cmbRoleService.Items.FindByValue(staff.RoleServiceId.ToString()));
}
txtTeam.Text = staff.Team;
if (!string.IsNullOrEmpty(staff.BranchCode))
{
ListItem item = cmbBranchCode.Items.FindByValue(staff.BranchCode);
if (item != null)
{
cmbBranchCode.SelectedIndex = cmbBranchCode.Items.IndexOf(item);
}
else
{
//Branch ที่ถูกปิด
string branchName = BranchBiz.GetBranchName(staff.BranchCode);
if (!string.IsNullOrEmpty(branchName))
{
cmbBranchCode.Items.Insert(1, new ListItem(branchName, staff.BranchCode));
cmbBranchCode.SelectedIndex = 1;
}
}
}
txtOldBranchCode.Text = staff.BranchCode;
if (staff.HeadStaffId != null)
{
string branchCode = StaffBiz.GetBranchCode(staff.HeadStaffId.Value);
if (!string.IsNullOrEmpty(branchCode))
{
ListItem item = cmbHeadBranchCode.Items.FindByValue(branchCode);
if (item != null)
{
cmbHeadBranchCode.SelectedIndex = cmbHeadBranchCode.Items.IndexOf(item);
}
else
{
//Branch ที่ถูกปิด
string branchName = BranchBiz.GetBranchName(branchCode);
if (!string.IsNullOrEmpty(branchName))
{
cmbHeadBranchCode.Items.Insert(1, new ListItem(branchName, branchCode));
cmbHeadBranchCode.SelectedIndex = 1;
}
}
}
cmbHeadBranchCode_SelectedIndexChanged();
cmbHeadStaffId.SelectedIndex = cmbHeadStaffId.Items.IndexOf(cmbHeadStaffId.Items.FindByValue(staff.HeadStaffId.Value.ToString()));
cmbHeadStaffId.Enabled = true;
lblHeadStaffId.Text = "*";
}
if (staff.DepartmentId != null)
{
cmbDepartment.SelectedIndex = cmbDepartment.Items.IndexOf(cmbDepartment.Items.FindByValue(staff.DepartmentId.ToString()));
}
if (staff.Is_Deleted != null)
{
txtOldIsDeleted.Text = staff.Is_Deleted.ToString();
txtNewIsDeleted.Text = staff.Is_Deleted.ToString();
if (staff.Is_Deleted == 0)
{
rdNormal.Checked = true;
}
else if (staff.Is_Deleted == 1)
{
rdRetire.Checked = true;
}
else
{
rdNormal.Checked = false;
rdRetire.Checked = false;
}
}
// level
if (staff.Level != null)
{
AppUtil.SetComboValue(cmbLevel, staff.Level.ToString());
}
// ประเภทพนักงาน
if (staff.Category != null)
{
AppUtil.SetComboValue(cmbCategory, staff.Category.ToString());
}
SetHostVisible();
// ชื่อบริษัท
if (staff.Host != null)
{
AppUtil.SetComboValue(cmbHost, staff.Host.ToString());
}
// ทีม Telesale
if (staff.TeamTelesale != null)
{
AppUtil.SetComboValue(cmbTeamTelesale, staff.TeamTelesale.ToString());
}
// load license data
gvLicense.DataSource = SlmScr018Biz.GetLicenseInfo(staff.EmpCode);
gvLicense.DataBind();
}
upInfo.Update();
}
catch
{
throw;
}
}
private void SaveData()
{
try
{
if (ValidateData())
{
int flag = 0;
StaffDataManagement data = new StaffDataManagement();
data.Username = txtUsername.Text.Trim();
data.UserType = rbnUserTypeIndividual.Checked ? "I" : "G";
data.EmpCode = txtEmpCode.Text.Trim();
data.EmpCodeOld = txtEmpCodeOld.Value.Trim();
data.MarketingCode = txtMarketingCode.Text.Trim();
data.IsMarketing = chkMarketing.Checked;
data.StaffNameTH = txtStaffNameTH.Text.Trim();
data.TelNo = txtTellNo.Text.Trim();
data.TelNo2 = txtTellNo2.Text.Trim();
data.TelNo3 = txtTellNo3.Text.Trim();
data.StaffEmail = txtStaffEmail.Text.Trim();
data.PositionId = int.Parse(cmbPosition.SelectedItem.Value);
data.StaffTypeId = decimal.Parse(cmbStaffType.SelectedItem.Value);
data.RoleServiceId = int.Parse(cmbRoleService.SelectedItem.Value);
data.Team = txtTeam.Text.Trim();
data.BranchCode = cmbBranchCode.SelectedItem.Value;
data.StaffId = int.Parse(txtStaffId.Text.Trim());
data.Level = AppUtil.SafeInt(cmbLevel.SelectedValue);
data.Category = AppUtil.SafeInt(cmbCategory.SelectedValue);
data.Host = AppUtil.SafeInt(cmbHost.SelectedValue);
data.TeamTelesale = AppUtil.SafeInt(cmbTeamTelesale.SelectedValue);
//data.InternalPhone = txtInternalPhone.Text;
//check if user = individual telno1 must not null
if (data.UserType == "I")
{
if (string.IsNullOrEmpty(data.TelNo))
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ #1");
return;
}
}
//telphone must not duplicate
if (!string.IsNullOrEmpty(data.TelNo) && !string.IsNullOrEmpty(data.TelNo2))
{
if (data.TelNo == data.TelNo2)
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ ไม่ซ้ำกัน");
return;
}
}
if (!string.IsNullOrEmpty(data.TelNo) && !string.IsNullOrEmpty(data.TelNo3))
{
if (data.TelNo == data.TelNo3)
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ ไม่ซ้ำกัน");
return;
}
}
if (!string.IsNullOrEmpty(data.TelNo2) && !string.IsNullOrEmpty(data.TelNo3))
{
if (data.TelNo2 == data.TelNo3)
{
AppUtil.ClientAlert(Page, "กรุณาระบุเบอร์โทรศัพท์ ไม่ซ้ำกัน");
return;
}
}
if (rdNormal.Checked == true)
{
data.Is_Deleted = 0;
}
else if (rdRetire.Checked == true)
{
data.Is_Deleted = 1;
}
if (cmbHeadStaffId.Items.Count > 0 && cmbHeadStaffId.SelectedItem.Value != "")
{
data.HeadStaffId = int.Parse(cmbHeadStaffId.SelectedItem.Value);
}
else
{
data.HeadStaffId = null;
}
if (cmbDepartment.Items.Count > 0)
{
if (!string.IsNullOrEmpty(cmbDepartment.SelectedItem.Value))
{
data.DepartmentId = int.Parse(cmbDepartment.SelectedItem.Value);
}
}
if (txtOldIsDeleted.Text.Trim() != txtNewIsDeleted.Text.Trim())
{
flag = 1;
}
var username = HttpContext.Current.User.Identity.Name;
if (AppConstant.CSMServiceEnableSyncUser)
{
try
{
var response = CSMService.InsertOrUpdateUser(2, data, username);
if (!response.IsSuccess)
{
if (response.ErrorCode == "7")
{
if (txtOldIsDeleted.Text.Trim() != txtNewIsDeleted.Text.Trim())
{
AppUtil.ClientAlert(Page, "บันทึกข้อมูลไม่สำเร็จ กรุณาโอนย้ายงาน SR ค้างที่ระบบ CSM ก่อน");
return;
}
if (data.BranchCode != txtOldBranchCode.Text)
{
AppUtil.ClientAlert(Page, "บันทึกข้อมูลไม่สำเร็จ กรุณาโอนย้ายงาน SR ค้างที่ระบบ CSM ก่อน");
return;
}
AppUtil.ClientAlert(Page, "การบันทึกข้อมูลไม่สำเร็จที่ ระบบ CSM");
return;
}
else
{
//AppUtil.ClientAlert(Page, "การบันทึกข้อมูลไม่สำเร็จที่ ระบบ CSM");
AppUtil.ClientAlert(Page, string.Format("{0} \r\nError Message : {1}", "การบันทึกข้อมูลไม่สำเร็จที่ ระบบ CSM", !string.IsNullOrEmpty(response.ErrorMessage) ? response.ErrorMessage : string.Empty));
return;
}
}
}
catch
{
AppUtil.ClientAlert(Page, "การบันทึกข้อมูลไม่สำเร็จเนื่องจากไม่สามารถเชื่อมต่อระบบ CSM");
return;
}
}
string staffId = SlmScr019Biz.UpdateStaff(data, username, flag);
AppUtil.ClientAlert(Page, "บันทึกข้อมูลเจ้าหน้าที่สำเร็จ");
txtStaffId.Text = staffId;
InitialControl();
LoadStaffData();
//SetDept();
upInfo.Update();
}
else
{
AppUtil.ClientAlert(Page, "กรุณาระบุข้อมูลให้ครบถ้วน");
}
}
catch
{
throw;
}
}
public static string UpdateStaff(StaffDataManagement data, string username, int flag)
{
return(KKSlmMsStaffDal.UpdateStaff(data, username, flag));
}
public static string InsertStaff(StaffDataManagement data, string username)
{
KKSlmMsStaffModel staff = new KKSlmMsStaffModel();
return(staff.InsertStaff(data, username));
}
public static string InsertStaff(StaffDataManagement data, string username)
{
return(KKSlmMsStaffDal.InsertStaff(data, username));
}
private void SaveData()
{
try
{
if (ValidateData())
{
int flag = 0;
StaffDataManagement data = new StaffDataManagement();
data.Username = txtUsername.Text.Trim();
data.EmpCode = txtEmpCode.Text.Trim();
data.MarketingCode = txtMarketingCode.Text.Trim();
data.StaffNameTH = txtStaffNameTH.Text.Trim();
data.TelNo = txtTellNo.Text.Trim();
data.StaffEmail = txtStaffEmail.Text.Trim();
data.PositionId = int.Parse(cmbPosition.SelectedItem.Value);
data.StaffTypeId = decimal.Parse(cmbStaffType.SelectedItem.Value);
data.Team = txtTeam.Text.Trim();
data.BranchCode = cmbBranchCode.SelectedItem.Value;
data.StaffId = int.Parse(txtStaffId.Text.Trim());
if (rdNormal.Checked == true)
{
data.Is_Deleted = 0;
}
else if (rdRetire.Checked == true)
{
data.Is_Deleted = 1;
}
if (cmbHeadStaffId.Items.Count > 0 && cmbHeadStaffId.SelectedItem.Value != "")
{
data.HeadStaffId = int.Parse(cmbHeadStaffId.SelectedItem.Value);
}
else
{
data.HeadStaffId = null;
}
if (cmbDepartment.Items.Count > 0)
{
if (!string.IsNullOrEmpty(cmbDepartment.SelectedItem.Value))
{
data.DepartmentId = int.Parse(cmbDepartment.SelectedItem.Value);
}
}
if (txtOldIsDeleted.Text.Trim() != txtNewIsDeleted.Text.Trim())
{
flag = 1;
}
string staffId = SlmScr019Biz.UpdateStaff(data, HttpContext.Current.User.Identity.Name, flag);
AppUtil.ClientAlert(Page, "บันทึกข้อมูลเจ้าหน้าที่สำเร็จ");
txtStaffId.Text = staffId;
InitialControl();
LoadStaffData();
//SetDept();
upInfo.Update();
}
else
{
AppUtil.ClientAlert(Page, "กรุณาระบุข้อมูลให้ครบถ้วน");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadStaffData()
{
try
{
StaffDataManagement staff = new StaffDataManagement();
if (txtStaffId.Text.Trim() != "")
{
staff = SlmScr018Biz.GetStaffData(int.Parse(txtStaffId.Text.Trim()));
}
if (staff != null)
{
txtUsername.Text = staff.Username;
lblUsername.Text = staff.Username;
txtEmpCode.Text = staff.EmpCode;
txtMarketingCode.Text = staff.MarketingCode;
txtStaffNameTH.Text = staff.StaffNameTH;
txtTellNo.Text = staff.TelNo;
txtStaffEmail.Text = staff.StaffEmail;
if (staff.PositionId != null)
{
cmbPosition.SelectedIndex = cmbPosition.Items.IndexOf(cmbPosition.Items.FindByValue(staff.PositionId.ToString()));
}
if (staff.StaffTypeId != null)
{
cmbStaffType.SelectedIndex = cmbStaffType.Items.IndexOf(cmbStaffType.Items.FindByValue(staff.StaffTypeId.ToString()));
}
txtTeam.Text = staff.Team;
if (!string.IsNullOrEmpty(staff.BranchCode))
{
ListItem item = cmbBranchCode.Items.FindByValue(staff.BranchCode);
if (item != null)
{
cmbBranchCode.SelectedIndex = cmbBranchCode.Items.IndexOf(item);
}
else
{
//Branch ที่ถูกปิด
string branchName = BranchBiz.GetBranchName(staff.BranchCode);
if (!string.IsNullOrEmpty(branchName))
{
cmbBranchCode.Items.Insert(1, new ListItem(branchName, staff.BranchCode));
cmbBranchCode.SelectedIndex = 1;
}
}
}
txtOldBranchCode.Text = staff.BranchCode;
if (staff.HeadStaffId != null)
{
string branchCode = StaffBiz.GetBranchCode(staff.HeadStaffId.Value);
if (!string.IsNullOrEmpty(branchCode))
{
ListItem item = cmbHeadBranchCode.Items.FindByValue(branchCode);
if (item != null)
{
cmbHeadBranchCode.SelectedIndex = cmbHeadBranchCode.Items.IndexOf(item);
}
else
{
//Branch ที่ถูกปิด
string branchName = BranchBiz.GetBranchName(branchCode);
if (!string.IsNullOrEmpty(branchName))
{
cmbHeadBranchCode.Items.Insert(1, new ListItem(branchName, branchCode));
cmbHeadBranchCode.SelectedIndex = 1;
}
}
}
cmbHeadBranchCode_SelectedIndexChanged();
cmbHeadStaffId.SelectedIndex = cmbHeadStaffId.Items.IndexOf(cmbHeadStaffId.Items.FindByValue(staff.HeadStaffId.Value.ToString()));
cmbHeadStaffId.Enabled = true;
lblHeadStaffId.Text = "*";
}
if (staff.DepartmentId != null)
{
cmbDepartment.SelectedIndex = cmbDepartment.Items.IndexOf(cmbDepartment.Items.FindByValue(staff.DepartmentId.ToString()));
}
if (staff.Is_Deleted != null)
{
txtOldIsDeleted.Text = staff.Is_Deleted.ToString();
txtNewIsDeleted.Text = staff.Is_Deleted.ToString();
if (staff.Is_Deleted == 0)
{
rdNormal.Checked = true;
}
else if (staff.Is_Deleted == 1)
{
rdRetire.Checked = true;
}
else
{
rdNormal.Checked = false;
rdRetire.Checked = false;
}
}
}
upInfo.Update();
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadStaffData()
{
try
{
StaffDataManagement staff = new StaffDataManagement();
if (txtStaffId.Text.Trim() != "")
{
staff = StaffBiz.GetStaff(int.Parse(txtStaffId.Text.Trim()));
}
if (staff != null)
{
txtUsername.Text = staff.Username;
lblUsername.Text = staff.Username;
txtEmpCode.Text = staff.EmpCode;
txtMarketingCode.Text = staff.MarketingCode;
txtStaffNameTH.Text = staff.StaffNameTH;
txtTellNo.Text = staff.TelNo;
txtStaffEmail.Text = staff.StaffEmail;
cmbPosition.SelectedIndex = cmbPosition.Items.IndexOf(cmbPosition.Items.FindByValue(staff.PositionId));
if (staff.StaffTypeId != null)
{
cmbStaffType.SelectedIndex = cmbStaffType.Items.IndexOf(cmbStaffType.Items.FindByValue(staff.StaffTypeId.ToString()));
}
txtTeam.Text = staff.Team;
cmbBranchCode.SelectedIndex = cmbBranchCode.Items.IndexOf(cmbBranchCode.Items.FindByValue(staff.BranchCode));
txtOldBranchCode.Text = staff.BranchCode;
cmbBranchCode_SelectedIndexChanged();
if (staff.HeadStaffId != null)
{
cmbHeadStaffId.SelectedIndex = cmbHeadStaffId.Items.IndexOf(cmbHeadStaffId.Items.FindByValue(staff.HeadStaffId.ToString()));
}
if (staff.DepartmentId != null)
{
cmbDepartment.SelectedIndex = cmbDepartment.Items.IndexOf(cmbDepartment.Items.FindByValue(staff.DepartmentId.ToString()));
}
if (!string.IsNullOrEmpty(staff.CocTeam) && cmbCocTeam.Items.Count > 0)
{
cmbCocTeam.SelectedIndex = cmbCocTeam.Items.IndexOf(cmbCocTeam.Items.FindByValue(staff.CocTeam));
txtCurrentCocTeam.Text = staff.CocTeam;
}
else
{
txtCurrentCocTeam.Text = "";
}
if (staff.Is_Deleted != null)
{
txtOldIsDeleted.Text = staff.Is_Deleted.ToString();
txtNewIsDeleted.Text = staff.Is_Deleted.ToString();
if (staff.Is_Deleted == 0)
{
rdNormal.Checked = true;
}
else if (staff.Is_Deleted == 1)
{
rdRetire.Checked = true;
}
else
{
rdNormal.Checked = false;
rdRetire.Checked = false;
}
}
}
upInfo.Update();
}
catch (Exception ex)
{
throw ex;
}
}
public static string UpdateStaff(StaffDataManagement data, string username, int flag)
{
KKSlmMsStaffModel staff = new KKSlmMsStaffModel();
return(staff.UpdateStaff(data, username, flag));
}
