private void CreateObject() { memberBLL = new MemberBLL(); countryBLL = new CountryBLL(); employeeBLL = new EmployeeBLL(); memberTypeBLL = new MemberTypeBLL(); callnameBLL = new CallNameBLL(); regencyBLL = new RegencyBLL(); }
private void CreateObject() { memberBLL = new MemberBLL(); memberTypeBLL = new MemberTypeBLL(); countryBLL = new CountryBLL(); employeeBLL = new EmployeeBLL(); exportExcelAlgorithms = new ExportExcelAlgorithms(); // receiptBLL = new ReceiptBLL(); }
protected void btnAddMember_Click(object sender, EventArgs e) { //Create the new department member DepartmentMember member = new DepartmentMember(); member.DepartmentFIS = STR_FRAC; member.FirstName = txtFName.Text; member.LastName = txtLName.Text; member.OtherDepartmentName = string.IsNullOrEmpty(txtDepartment.Text) ? "Other" : txtDepartment.Text; member.LoginID = txtLoginID.Text.ToLower().Trim(); //Create the membership object CommitteeMember committeeAccess = new CommitteeMember(); committeeAccess.AssociatedPosition = currentPosition; committeeAccess.DepartmentMember = member; switch (dlistMemberType.SelectedValue) { case "Committee": committeeAccess.MemberType = MemberTypeBLL.GetByID((int)MemberTypes.CommitteeMember); break; case "Faculty": committeeAccess.MemberType = MemberTypeBLL.GetByID((int)MemberTypes.FacultyMember); break; case "Review": committeeAccess.MemberType = MemberTypeBLL.GetByID((int)MemberTypes.Reviewer); break; } //save the department member and add to the position committee for this position using (var ts = new TransactionScope()) { DepartmentMemberBLL.EnsurePersistent(member); committeeAccess.DepartmentMember = member; currentPosition.CommitteeMembers.Add(committeeAccess); Position position = currentPosition; PositionBLL.EnsurePersistent(position); ts.CommitTransaction(); } //Display an update successful message lblCommitteeUpdated.Text = "Committee Membership Successfully Updated"; //rebind the datagrid this.bindMembers(); this.ShowUpdateAcessRegion(); }
private void LoadCmbType() { MemberTypeBLL mtbll = new MemberTypeBLL(); List <MemberType> list = mtbll.getAll() as List <MemberType>; list.Insert(0, new MemberType { MemTypeName = "请选择", MemType = -1 }); cmbType.DataSource = list; cmbType.DisplayMember = "MemTypeName"; cmbType.ValueMember = "MemType"; }
private void LoadMemberTypeByDelFlag(int p) { var bll = new MemberTypeBLL(); var list = bll.GetAllMemberTypeByDelFlag(p); list.Insert(0, new MemberType() { MemType = -1, MemTpName = "请选择" }); cmbMemType.DataSource = list; cmbMemType.DisplayMember = "MemTpName"; cmbMemType.ValueMember = "MemType"; }
private void LoadMemberType(int delFlag) { MemberTypeBLL mtbll = new MemberTypeBLL(); List <MemberType> list = new List <MemberType>(); list = mtbll.GetAllMemberTypeByDelFlag(delFlag); list.Insert(0, new MemberType() { MemTypeName = "请选择", MemType = -1 }); cmbType.DataSource = list; cmbType.DisplayMember = "MemTypeName"; cmbType.ValueMember = "MemType"; }
private void cmbMemmber_SelectedValueChanged(object sender, EventArgs e) { if (cmbMemmber.SelectedIndex != 0) { var member = cmbMemmber.SelectedItem as MemberInfo; lblDis.Text = member.MemDiscount.ToString(); labyeMoney.Text = member.MemMoney.ToString(); var bll = new MemberTypeBLL(); labTp.Text = bll.GetMemberTypeByType(Convert.ToInt32(member.MemType)); lblMoney.Text = (Convert.ToDecimal(labMoney.Text) * Convert.ToDecimal(lblDis.Text) / 10).ToString(); } else { lblDis.Text = ""; labyeMoney.Text = ""; labTp.Text = ""; lblMoney.Text = labMoney.Text; } }
public override void LoadData() { base.LoadData(); DepartmentMember departmentMember = new DepartmentMember { DepartmentFIS = StaticProperties.TestString, FirstName = StaticProperties.TestString, LastName = StaticProperties.TestString, LoginID = StaticProperties.TestString, OtherDepartmentName = StaticProperties.TestString }; using (var ts = new TransactionScope()) { DepartmentMemberBLL.EnsurePersistent(departmentMember); for (int i = 0; i < 4; i++) { var memberType = new MemberType { Type = StaticProperties.TestString }; var committeeMember = new CommitteeMember { AssociatedPosition = PositionBLL.GetByID(StaticProperties.ExistingPositionID), DepartmentMember = departmentMember, MemberType = memberType }; MemberTypeBLL.EnsurePersistent(memberType); CommitteeMemberBLL.EnsurePersistent(committeeMember); } ts.CommitTransaction(); } }
public static void UpdateAccess(DepartmentMember member, Position position, bool committee, bool faculty, bool reviewer) { //Now get all committee roles for this member List <CommitteeMember> memberAccess = CommitteeMemberBLL.GetByAssociationsPosition(position, member); CommitteeMember currentMember = new CommitteeMember(); currentMember.DepartmentMember = member; currentMember.AssociatedPosition = position; //First check for Committee Member access CommitteeMember currentMemberAccess = DepartmentMemberBLL.MemberInCommitteeListOfType(memberAccess, MemberTypes.CommitteeMember); if (currentMemberAccess == null) { //member is not in the committee list. If the box is checked, add them to the committee list if (committee) { CommitteeMember newMemberAccess = new CommitteeMember(); newMemberAccess.DepartmentMember = member; newMemberAccess.AssociatedPosition = position; newMemberAccess.MemberType = MemberTypeBLL.GetByID((int)MemberTypes.CommitteeMember); position.CommitteeMembers.Add(newMemberAccess); } } else { //member is in the committee list. Remove if the box is unchecked if (!committee) { position.CommitteeMembers.Remove(currentMemberAccess); } } //Now check for Faculty Member access currentMemberAccess = DepartmentMemberBLL.MemberInCommitteeListOfType(memberAccess, MemberTypes.FacultyMember); if (currentMemberAccess == null) { //member is not in the faculty list. If the box is checked, add them if (faculty) { CommitteeMember newMemberAccess = new CommitteeMember(); newMemberAccess.DepartmentMember = member; newMemberAccess.AssociatedPosition = position; newMemberAccess.MemberType = MemberTypeBLL.GetByID((int)MemberTypes.FacultyMember); position.CommitteeMembers.Add(newMemberAccess); } } else { //member is in the committee list. Remove if the box is unchecked if (!faculty) { position.CommitteeMembers.Remove(currentMemberAccess); } } //Finally check for review member access currentMemberAccess = DepartmentMemberBLL.MemberInCommitteeListOfType(memberAccess, MemberTypes.Reviewer); if (currentMemberAccess == null) { //member is not in the reviewer list. If the box is checked, add them if (reviewer) { CommitteeMember newMemberAccess = new CommitteeMember(); newMemberAccess.DepartmentMember = member; newMemberAccess.AssociatedPosition = position; newMemberAccess.MemberType = MemberTypeBLL.GetByID((int)MemberTypes.Reviewer); position.CommitteeMembers.Add(newMemberAccess); } } else { //member is in the committee list. Remove if the box is unchecked if (!reviewer) { position.CommitteeMembers.Remove(currentMemberAccess); } } //Position position = position; PositionBLL.EnsurePersistent(position); }
private void btnSave_Click(object sender, EventArgs e) { //rTxtLog.Text = string.Empty; Cursor.Current = Cursors.WaitCursor; string connString = string.Empty; string status = "Status: \t"; string serror = "Error: \t"; string swaring = "Waring: \t"; BusinessLayer.BLLCRM.MemberBLL memberBLL = new BusinessLayer.BLLCRM.MemberBLL(); if (validation()) { rTxtLog.AppendText(status + "Opening Excel File...\n"); rTxtLog.AppendText(status + "File is opened, waiting for welcome message...\n"); DataTable dtExcel = VVPosM1.BusinessLayer.BLLCRM.ImportMember.ReadExcelFile(filepath); Boolean bFlagUpdate = false; int iRowError = 0; int iRowSuccess = 0; int iTotalRecord = 0; //Set Column Label string strMemberCode = txtMemberCode.Text.Trim(); string[] strFullName = txtMemerName.Text.Split(';'); string strChucDanh = txtChucDanh.Text.Trim(); string strCompanyName = txtCompanyName.Text.Trim(); string strAddress = txtAddress.Text.Trim(); string[] strEmails = txtCompanyEmail.Text.Split(';'); string strPhone = txtPhoneNumber.Text; string strmPhone = txtMobilePhone.Text; string strWebsite = txtWebsite.Text; string strTaxCode = txtTaxCode.Text; string[] strNotes = txtDescription.Text.Split(';'); string strBirthDay = txtBirthday.Text; int iTemps = -1; string strTemp = string.Empty; int iBegin = (int.Parse(txtFirstLine.Text) - 1) > 0 ? int.Parse(txtFirstLine.Text) - 1 : 0; for (int iCount = iBegin; iCount < int.Parse(txtEndLine.Text); iCount++) { if (iCount >= dtExcel.Rows.Count) { break; } DataRow dr = dtExcel.Rows[iCount]; Entities.Member member = new Entities.Member(); int iLineError = 0; //Count total record iTotalRecord++; rTxtLog.AppendText("Reading line: " + iTotalRecord.ToString() + "\n"); //Get Col MemberCode if (chBAutoID.Checked == true) { try { member.MemberCode = BusinessLayer.BLLCRM.ImportMember.GetAutoMemberCode(); } catch (Exception) { rTxtLog.AppendText(swaring + "Customer code is null.\n"); iLineError++; } } else { iTemps = BusinessLayer.BLLCRM.ImportMember.returnCellName(strMemberCode); try { if (dr[iTemps].ToString() != string.Empty) { member.MemberCode = dr[iTemps].ToString(); //Check exists if (chBOveride.Checked == true) { if (memberBLL.CheckMemberCodeExist(member.MemberCode)) { if (memberBLL.getMemberId(member.MemberCode) != string.Empty) { member.MemberId = memberBLL.getMemberId(member.MemberCode); bFlagUpdate = true; } else { rTxtLog.AppendText(serror + "Customer ID is not getted. SQL command error.\n"); iLineError++; } } } } else { rTxtLog.AppendText(serror + "Customer code is null.\n"); iLineError++; } } catch (Exception) { rTxtLog.AppendText(serror + "Customer code is null.\n"); iLineError++; } } //Get Fullname strTemp = string.Empty; if (strFullName.Length > 0) { foreach (var item in strFullName) { if (item != "") { iTemps = BusinessLayer.BLLCRM.ImportMember.returnCellName(item.Trim()); try { strTemp += dr[iTemps].ToString() + " "; } catch (Exception) { rTxtLog.AppendText(serror + "Column " + item + ": data not found.\n"); //iLineError++; } } } } member.MemberName = strTemp.Trim(); //Get Chuc Danh if (strChucDanh != string.Empty) { iTemps = BusinessLayer.BLLCRM.ImportMember.returnCellName(strChucDanh); try { member.Regency = dr[iTemps].ToString(); } catch (Exception) { member.Regency = string.Empty; rTxtLog.AppendText(serror + "Column " + strChucDanh + ": data not found.\n"); } } else { member.Regency = string.Empty; } //Get Company name if (strCompanyName != string.Empty) { iTemps = BusinessLayer.BLLCRM.ImportMember.returnCellName(strCompanyName); try { member.CompanyName = dr[iTemps].ToString(); } catch (Exception) { member.CompanyName = string.Empty; rTxtLog.AppendText(serror + "Column " + strCompanyName + ": data not found.\n"); } } else { member.CompanyName = string.Empty; } //Check Member name or Company name is not null if (member.MemberName == string.Empty && member.CompanyName == string.Empty) { iLineError++; rTxtLog.AppendText(serror + "Customer name or company name are not null.\n"); } else { if (member.MemberName == string.Empty) { rTxtLog.AppendText(swaring + "Customer name is null\n"); } if (member.CompanyName == string.Empty) { rTxtLog.AppendText(swaring + "Company name is null\n"); } } //Get Address if (strAddress != string.Empty) { iTemps = BusinessLayer.BLLCRM.ImportMember.returnCellName(strAddress); try { member.Address = dr[iTemps].ToString(); } catch (Exception) { member.Address = string.Empty; rTxtLog.AppendText(serror + "Column " + strAddress + ": data not found.\n"); } } else { member.Address = string.Empty; } //Get Email strTemp = string.Empty; int iTemp = 1; if (strEmails.Length > 0) { foreach (var item in strEmails) { if (item != "") { try { iTemps = BusinessLayer.BLLCRM.ImportMember.returnCellName(item.Trim()); if (Common.Validation.ValidateEmail(dr[iTemps].ToString())) { strTemp += dr[iTemps].ToString() + ";"; } else { rTxtLog.AppendText(swaring + "Email " + iTemp + ": incorrect email format.\n"); iTemp++; //iLineError++; } } catch (Exception) { rTxtLog.AppendText(swaring + "Column " + item + ": data not found.\n"); //iLineError++; } } } } char[] charsToTrim = { ',', '.', ' ', ';' }; strTemp = strTemp.Trim(); strTemp = strTemp.TrimEnd(charsToTrim); member.CompanyEmail = strTemp; member.Email = strTemp; //Get Phone number if (strPhone != string.Empty) { iTemps = ImportMember.returnCellName(strPhone); try { member.PhoneNumber = dr[iTemps].ToString(); } catch (Exception) { member.PhoneNumber = string.Empty; rTxtLog.AppendText(swaring + "Column " + strPhone + ": data not found.\n"); } } else { member.PhoneNumber = string.Empty; } //Get mobile phone if (strmPhone != string.Empty) { iTemps = ImportMember.returnCellName(strmPhone); try { member.MobilePhone = dr[iTemps].ToString(); } catch (Exception) { member.MobilePhone = string.Empty; rTxtLog.AppendText(swaring + "Column " + strmPhone + ": data not found.\n"); } } else { member.MobilePhone = string.Empty; } //Get Tax code if (strTaxCode != string.Empty) { iTemps = ImportMember.returnCellName(strTaxCode); try { member.TaxCode = dr[iTemps].ToString(); } catch (Exception) { member.TaxCode = string.Empty; rTxtLog.AppendText(swaring + "Column " + strTaxCode + ": data not found.\n"); } } else { member.TaxCode = string.Empty; } //Get website if (strWebsite != string.Empty) { iTemps = ImportMember.returnCellName(strWebsite); try { if (Common.Validation.ValidateWebsite(dr[iTemps].ToString())) { member.Website = dr[iTemps].ToString(); } else { rTxtLog.AppendText(swaring + "Website incorrect format.\n"); } } catch (Exception) { member.Website = string.Empty; rTxtLog.AppendText(swaring + "Column " + strWebsite + ": data not found.\n"); } } else { member.Website = string.Empty; } strTemp = string.Empty; iTemp = 1; if (strNotes.Length > 0) { foreach (var item in strNotes) { iTemps = ImportMember.returnCellName(item.Trim()); try { strTemp += (dr[iTemps].ToString() + "'\r\n'"); } catch (Exception) { rTxtLog.AppendText(swaring + "Column " + item + ": data not found.\n"); } } } member.Description = strTemp; //Get birthday if (strBirthDay != string.Empty) { iTemps = ImportMember.returnCellName(strBirthDay); try { member.birthDay = true; member.BirthDate = DateTime.ParseExact(dr[iTemps].ToString(), cbbDatetimeFormat.SelectedItem.ToString(), System.Globalization.DateTimeFormatInfo.CurrentInfo, System.Globalization.DateTimeStyles.None); //Common.Utility.StringToDateTimeVer2(dr[iTemps].ToString()); } catch (Exception) { member.birthDay = false; //member.BirthDate = DateTime.Now; rTxtLog.AppendText(swaring + "Column " + strBirthDay + ": data not found.\n"); } } else { member.birthDay = false; member.BirthDate = DateTime.Now; } //creator member.Creator.EmployeeId = Program.employee1.EmployeeId; member.Curator.EmployeeId = cbbCreator.SelectedValue.ToString(); //Get Country ID OT member.Country.CountryId = countryID; //Member Type List <Entities.MemberType> lstMemberTypeName = new List <Entities.MemberType>(); MemberTypeBLL mt = new MemberTypeBLL(); DataTable dt = mt.GetLists(); Entities.MemberType mbt = new Entities.MemberType(); int iFlag = 0; foreach (DataRow drtemp in dt.Rows) { if (drtemp["MemberTypeCode"].ToString().Equals("OT")) { mbt.MemberTypeId = int.Parse(drtemp["MemberTypeId"].ToString()); mbt.MemberTypeName = drtemp["MemberTypeName"].ToString(); mbt.MemberTypeName2 = drtemp["MemberTypeName2"].ToString(); mbt.MemberTypeName3 = drtemp["MemberTypeName3"].ToString(); mbt.MemberTypeCode = drtemp["MemberTypeCode"].ToString(); iFlag = 1; break; } } if (iFlag == 0) { mbt.MemberTypeId = int.Parse(dt.Rows[0]["MemberTypeId"].ToString()); mbt.MemberTypeName = dt.Rows[0]["MemberTypeName"].ToString(); mbt.MemberTypeName2 = dt.Rows[0]["MemberTypeName2"].ToString(); mbt.MemberTypeName3 = dt.Rows[0]["MemberTypeName3"].ToString(); mbt.MemberTypeCode = dt.Rows[0]["MemberTypeCode"].ToString(); } lstMemberTypeName.Add(mbt); member.List_MemberType = lstMemberTypeName; //member.Email = string.Empty; member.TotalScore = 0; member.CurrentScore = 0; member.NumberOfVissits = 0; member.IsLock = 0; member.CallName.CallNameID = CallNameID; //Lastest Date member.LastestDate = DateTime.Now; //Created date member.CreatedDate = DateTime.Now; //Updated date member.UpdatedDate = DateTime.Now; if (chBOveride.Checked == true) { if (bFlagUpdate == true) { try { memberBLL.Edit(member); } catch (Exception) { rTxtLog.AppendText(status + "Row " + iTotalRecord.ToString() + " is not update.\n"); iLineError++; } } else { try { if (!memberBLL.CheckMemberCodeExist(member.MemberCode)) { memberBLL.Add(member); } else { rTxtLog.AppendText(status + "Row " + iTotalRecord.ToString() + ": member code is exists.\n"); iLineError++; } } catch (Exception) { rTxtLog.AppendText(status + "Row " + iTotalRecord.ToString() + " is not insert.\n"); iLineError++; } } } else { try { if (!memberBLL.CheckMemberCodeExist(member.MemberCode)) { memberBLL.Add(member); } else { rTxtLog.AppendText(status + "Row " + iTotalRecord.ToString() + ": member code is exists.\n"); iLineError++; } } catch (Exception) { rTxtLog.AppendText(status + "Row " + iTotalRecord.ToString() + " is not insert.\n"); iLineError++; } } if (iLineError == 0) { rTxtLog.AppendText(status + "Row " + iTotalRecord.ToString() + " is inserted database.\n"); iRowSuccess++; } else { rTxtLog.AppendText(status + "Row " + iTotalRecord.ToString() + " is error.\n"); iRowError++; } iLineError = 0; } rTxtLog.AppendText(status + "Closing Excel File...\n"); rTxtLog.AppendText(status + "File is closed\n"); rTxtLog.AppendText(iRowError + " error record. " + iRowSuccess + " success record.\n"); rTxtLog.AppendText("Total " + iTotalRecord.ToString() + " record.\n"); CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("CRM629"), Common.clsLanguages.GetResource("CRM11"), Common.Config.CUSTOM_MESSAGEBOX_ICON.Information, Common.Config.CUSTOM_MESSAGEBOX_BUTTON.OK); } }