/*
* private void UpdateMsSQL(SqlConnection con2, int DirCustomersID)
* {
* using (SqlCommand cmd = new SqlCommand("INSERT INTO DirCustomersHistory (DirCustomersHistoryTypeID, DirCustomersID)values(1, @DirCustomersID)", con2))
* {
* SQLiteParameter parDirCustomersID = new SQLiteParameter("@DirCustomersID", System.Data.SqlDbType.Int); cmd.Parameters.Add(parDirCustomersID).Value = DirCustomersID;
* cmd.ExecuteNonQuery();
* }
* }
*/
private void SendMail(string pEMail)
{
//Class.Functions.FunMailSend funMailSend = new Class.Functions.FunMailSend();
Classes.Function.FunctionMSSQL.FunMailSend funMailSend = new Classes.Function.FunctionMSSQL.FunMailSend();
funMailSend.SendTo_OtherEMail("Напоминание паролей в 'ВТорговомОблаке'. Складской учет и торговля онлайн.", TextMail(pEMail), pEMail);
try { funMailSend.SendTo_ESklad24("Напоминание паролей.", "Для EMail: " + pEMail); }
catch { }
}
private void SendMail()
{
//Class.Functions.FunMailSend funMailSend = new Class.Functions.FunMailSend();
Classes.Function.FunctionMSSQL.FunMailSend funMailSend = new Classes.Function.FunctionMSSQL.FunMailSend();
funMailSend.SendTo_OtherEMail("Подтверждение регистрации в Web-сервисе 'ВТорговомОблаке'. Складской учет онлайн.", TextMail(), pEMail);
try { funMailSend.SendTo_ESklad24("Подтверждение регистрации.", "Login: "******"<br />Клиент получил следующий текст:<hr />" + TextMail()); }
catch { }
}
private bool mRegistration(Models.Login.Dir.DirCustomerReg dirCustomerReg, int iLanguage)
{
//Для записи в БД, т.к. использовать "dirCustomerReg" нельзя!
Models.Login.Dir.DirCustomer dirCustomer = new Models.Login.Dir.DirCustomer();
if (dirCustomerReg != null && ModelState.IsValid)
{
try
{
using (DbConnectionLogin con = new DbConnectionLogin("ConnStrMSSQL"))
{
#region Проверка
// на существования такого логина
int iCount =
(
(
from dirCustomers in con.DirCustomers
where dirCustomers.Login == dirCustomerReg.Login
select dirCustomers.Login
).Concat
(
from dirLoginNot in con.DirLoginNot
where dirLoginNot.Login == dirCustomerReg.Login
select dirLoginNot.Login
)
).Count();
if (iCount > 0)
{
con.Database.Connection.Close(); ViewData["Msg"] = Classes.Language.Login.Language.msg1(iLanguage); return(false);
}
// на существования такого реферала
if (dirCustomerReg.Refer != 0)
{
int iCountRefer =
(
from DirCustomers in con.DirCustomers
where dirCustomerReg.DirCustomersID == dirCustomerReg.Refer
select dirCustomerReg.Login
).Count();
if (iCountRefer == 0)
{
dirCustomerReg.Refer = 0;
}
}
#endregion
#region Сохраняем
//Формирование пароля
Classes.Function.FunctionMSSQL.RandomSymbol randomSymbol = new Classes.Function.FunctionMSSQL.RandomSymbol();
dirCustomerReg.Pswd = randomSymbol.ReturnRandom(10);
//Переносим данные в "нужную" модель: dirCustomerReg => dirCustomer
dirCustomer.DirCustomersDate = DateTime.Now;
dirCustomer.Email = dirCustomerReg.Email;
dirCustomer.Login = dirCustomerReg.Login;
dirCustomer.DomainName = dirCustomerReg.Login;
dirCustomer.Pswd = dirCustomerReg.Pswd;
dirCustomer.Telefon = dirCustomerReg.Telefon;
dirCustomer.FIO = dirCustomerReg.FIO;
dirCustomer.DirLanguageID = dirCustomerReg.DirLanguageID;
dirCustomer.DirCountryID = dirCustomerReg.DirCountryID;
dirCustomer.Refer = dirCustomerReg.Refer;
dirCustomer.SendMail = false;
dirCustomer.Active = false;
dirCustomer.Pay = true;
dirCustomer.Confirmed = false;
con.Entry(dirCustomer).State = EntityState.Added;
try
{
con.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (var failure in ex.EntityValidationErrors)
{
//sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
foreach (var error in failure.ValidationErrors)
{
sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
sb.AppendLine();
}
}
throw new System.Data.Entity.Validation.DbEntityValidationException(
//"Entity Validation Failed - errors follow:\n" +
sb.ToString(), ex
); // Add the original exception as the innerException
}
/*catch (Exception ex)
* {
* throw new System.InvalidOperationException(ex.Message);
* }*/
#endregion
}
#region Отправка письма на E-Mail
try
{
//Текс на русском
string sSendTest = Classes.Language.Login.Language.txtRegistrationMail(dirCustomer, iLanguage);
Classes.Function.FunctionMSSQL.FunMailSend funMailSend = new Classes.Function.FunctionMSSQL.FunMailSend();
//Отправка клиенту
funMailSend.SendTo_OtherEMail(Classes.Language.Login.Language.msg2(iLanguage), sSendTest, dirCustomer.Email);
//Отправка себе
try { funMailSend.SendTo_ESklad24(Classes.Language.Login.Language.msg2(iLanguage), "E-Mail: " + dirCustomer.Email + ", Login: "******"<br />" + Classes.Language.Login.Language.msg2(iLanguage) + "<hr />" + sSendTest); } catch { }
}
catch (Exception ex)
{
ViewData["Msg"] = Classes.Language.Login.Language.msg4(iLanguage) + ex.Message + "";
ViewData["Title"] = Classes.Language.Login.Language.msg5(iLanguage);
return(true);
}
#endregion
using (DbConnectionLogin con = new DbConnectionLogin("ConnStrMSSQL"))
{
#region Пишем в БД, что Мейл отправлен (SendMail=true)
dirCustomer.SendMail = true;
con.Entry(dirCustomer).State = EntityState.Modified;
con.SaveChanges();
#endregion
}
}
catch (Exception ex)
{
string sMsg = exceptionEntry.Return(ex);
ViewData["Msg"] = Classes.Language.Login.Language.error(iLanguage) + ": <br />" + sMsg + "<br /> " + Classes.Language.Login.Language.msg6(iLanguage) + ": <a href='mailto:[email protected]' rel='nofollow'>[email protected]</a>"; return(false);
}
ViewData["Title"] = Classes.Language.Login.Language.msg5(iLanguage);
ViewData["Msg"] = Classes.Language.Login.Language.msg7(iLanguage);
return(true);
}
else
{
return(false);
}
}