public static string GetAutoMemberCode() { BusinessLayer.BLLCRM.MemberBLL memberBLL = new BusinessLayer.BLLCRM.MemberBLL(); string pQG = ""; string pNamThangNgay = ""; int pAutoID = 1; pQG = "OT"; pNamThangNgay = DateTime.Now.ToString("yy") + DateTime.Now.ToString("MM") + DateTime.Now.ToString("dd"); string pkq = "0"; try { pkq = memberBLL.GetMemberCode(); } catch (Exception) { pkq = (pkq == "") ? "0" : pkq; } pAutoID = int.Parse(pkq.ToString()) + 1; string pKqAuto = ""; if (pAutoID < 10) { pKqAuto = "0000" + pAutoID; } else if (pAutoID >= 10 && pAutoID < 100) { pKqAuto = "000" + pAutoID; } else if (pAutoID >= 100 && pAutoID < 1000) { pKqAuto = "00" + pAutoID; } else if (pAutoID >= 1000 && pAutoID < 10000) { pKqAuto = "0" + pAutoID; } else { pKqAuto = pAutoID.ToString(); } return(pQG + pNamThangNgay + pKqAuto); }
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); } }