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);
}
}
