//-----------------------------------------------
//LoadObject
//-----------------------------------------------
protected override object LoadObject()
{
MailListUsersEntity mailListUsers = new MailListUsersEntity();
mailListUsers.Email = txtEmail.Text;
mailListUsers.IsActive = cbIsActive.Checked;
if (SiteSettings.MailList_HasGroups)
{
//-------------------------------------------------------
string groups = "";
foreach (ListItem item in ddlMailListGroups.Items)
{
if (item.Selected)
{
groups += "#" + item.Value + "#";
}
}
mailListUsers.Groups = groups;
}
mailListUsers.ModuleTypeID = (int)StandardItemsModuleTypes.MailList;
//---------------------------------------------------------------------
//Language
//---------------------------------------------------------------------
Languages langID = (Languages)SiteSettings.Languages_DefaultLanguageID;
if (SiteSettings.Languages_HasMultiLanguages)
{
langID = (Languages)Convert.ToInt32(ddlLanguages.SelectedValue);
}
//--------------------------------------
mailListUsers.LangID = langID;
//---------------------------------------------------------------------
return(mailListUsers);
}
//-----------------------------------------------
//SaveData
//-----------------------------------------------
protected override object SaveData()
{
MailListUsersEntity mailListUser = (MailListUsersEntity)LoadObject();
if (mailListUser != null)
{
status = MailListUsersFactory.Create(mailListUser);
}
return(mailListUser);
}
protected void SendEmail(MailListUsersEntity user)
{
// prepare message
string body = string.Format(DynamicResource.GetText("MailList", "ActivationMailBody"), new string[3] {
SitesHandler.GetSiteDomain(), Encryption.Encrypt(user.UserID.ToString()), user.Email
});
//string from =MailListEmailsFactory.MailFrom;
MailListEmailsEntity mail = new MailListEmailsEntity();
mail.Subject = DynamicResource.GetText("MailList", "ActivationMailSubject");
mail.Body = body;
mail.To.Add(user.Email);
MailListEmailsFactory.Send(mail);
}
//--------------------------------------------------------
#endregion
#region ---------------btnSave_Click---------------
//-----------------------------------------------
//btnSave_Click
//-----------------------------------------------
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
int userID = Convert.ToInt32(Request.QueryString["id"]);
MailListUsersEntity mailListUser = MailListUsersFactory.GetObject(userID);
mailListUser.UserID = userID;
mailListUser.Email = txtEmail.Text;
mailListUser.IsActive = cbIsActive.Checked;
if (SiteSettings.MailList_HasGroups)
{
//mailListUser.GroupID = Convert.ToInt32(ddlMailListGroups.SelectedValue);
string groups = "";
foreach (ListItem item in ddlMailListGroups.Items)
{
if (item.Selected)
{
groups += "#" + item.Value + "#";
}
}
mailListUser.Groups = groups;
}
ExecuteCommandStatus status = MailListUsersFactory.Update(mailListUser);
if (status == ExecuteCommandStatus.Done)
{
lblResult.Text = Resources.AdminText.SavingDataSuccessfuly;
Response.Redirect("default.aspx");
}
else if (status == ExecuteCommandStatus.AllreadyExists)
{
lblResult.CssClass = "lblResult_Faild";
lblResult.Text = Resources.AdminText.DuplicateItem;
}
else
{
lblResult.CssClass = "lblResult_Faild";
lblResult.Text = Resources.AdminText.SavingDataFaild;
}
}
protected void ibtnEmailSubscripe_Click(object sender, ImageClickEventArgs e)
{
//-------------------------------------
if (!Page.IsValid)
{
return;
}
//-------------------------------------
MailListUsersEntity mailListUsers;
ExecuteCommandStatus status;
Languages langID = SiteSettings.GetCurrentLanguage();
mailListUsers = new MailListUsersEntity();
mailListUsers.LangID = langID;
//mailListUsers.Groups = groups;
mailListUsers.ModuleTypeID = (int)StandardItemsModuleTypes.MailList;
mailListUsers.Email = txtEMail.Text;
status = MailListUsersFactory.Create(mailListUsers);
if (status == ExecuteCommandStatus.Done)
{
lblResult.CssClass = "operation_done";
lblResult.Text = DynamicResource.GetText("MailList", "SubscripeDone");
// Clear controls;
txtEMail.Text = "";
}
else if (status == ExecuteCommandStatus.AllreadyExists)
{
lblResult.CssClass = "operation_error";
lblResult.Text = DynamicResource.GetText("MailList", "ExistsEmail");
}
else
{
lblResult.CssClass = "operation_error";
lblResult.Text = DynamicResource.GetText("MailList", "SubscripeFailed");
}
}
//--------------------------------------------------------
#endregion
#region --------------LoadData()--------------
//---------------------------------------------------------
//LoadData
//---------------------------------------------------------
protected void LoadData()
{
if (MoversFW.Components.UrlManager.ChechIsValidParameter("id"))
{
int userID = Convert.ToInt32(Request.QueryString["id"]);
MailListUsersEntity mailListUser = MailListUsersFactory.GetObject(userID);
if (mailListUser != null)
{
txtEmail.Text = mailListUser.Email;
cbIsActive.Checked = mailListUser.IsActive;
if (SiteSettings.MailList_HasGroups)
{
//ddlMailListGroups.SelectedValue = mailListUser.GroupID.ToString();
//string groupsText = mailListUser.Groups.Replace("##", "#");
string[] groups = mailListUser.Groups.Split(new char[] { '#' });
foreach (string group in groups)
{
if (!string.IsNullOrEmpty(group))
{
foreach (ListItem item in ddlMailListGroups.Items)
{
if (item.Value == group)
{
item.Selected = true;
}
}
}
}
}
}
}
else
{
Response.Redirect("default.aspx");
}
}
//-----------------------------------------------
//SaveData
//-----------------------------------------------
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
//--------------------------------------
if (fuNumbers.HasFile)
{
if (fuNumbers.PostedFile.ContentType == "text/plain")
{
string fileName = DCServer.MapPath(DCSiteUrls.GetPath_MailList_AttachmentDir() + fuNumbers.FileName);
fuNumbers.SaveAs(fileName);
//---------------------------------------
string[] mailsToImport = File.ReadAllLines(fileName);
int count = 0;
//---------------------------------------
int successfullyMailsCount = 0;
string existsMails = "";
int existsMailsCount = 0;
string failedMails = "";
int failedMailsCount = 0;
string notMails = "";
int notMailsCount = 0;
//---------------------------------------------------------------------
MailListUsersEntity mailUser = new MailListUsersEntity();
ExecuteCommandStatus status;
//---------------------------------------------------------------------
//props
//---------------------------------------------------------------------
Languages langID = (Languages)SiteSettings.Languages_DefaultLanguageID;
if (SiteSettings.Languages_HasMultiLanguages)
{
langID = (Languages)Convert.ToInt32(ddlLanguages.SelectedValue);
}
//-------------------------------------------
mailUser.LangID = langID;
//-------------------------------------------
mailUser.IsActive = cbIsActive.Checked;
//-------------------------------------------
if (ddlMailListGroups.SelectedValue != "-1")
{
mailUser.GroupID = Convert.ToInt32(ddlMailListGroups.SelectedValue);
mailUser.Groups = "#" + mailUser.GroupID + "#";
}
//---------------------------------------------------------------------
bool isEmail = false;
//---------------------------------------------------------------------
foreach (string email in mailsToImport)
{
try
{
isEmail = false;
isEmail = DCValidation.IsEmail(email);
if (isEmail)
{
mailUser.Email = email;
status = MailListUsersFactory.Create(mailUser);
switch (status)
{
case ExecuteCommandStatus.Done:
++successfullyMailsCount;
break;
case ExecuteCommandStatus.AllreadyExists:
existsMails += email + "<br>";
++existsMailsCount;
break;
case ExecuteCommandStatus.UnknownError:
failedMails += email + "<br>";
++failedMailsCount;
break;
default:
failedMails += email + "<br>";
++failedMailsCount;
break;
}
}
else
{
notMails += email + "<br>";
++notMailsCount;
}
}
catch (Exception ex)
{
notMails += email + "<br>";
++notMailsCount;
}
}
//---------------------------------------------------------------------------------------------
lblSuccessfulyMails.Text = string.Format(Resources.MailListAdmin.ImportSuccessfulyCount, successfullyMailsCount);
lblNotMails.Text = string.Format(Resources.MailListAdmin.NotImportNotMailsCount, notMailsCount) + " <br />" + notMails;
lblExistsMails.Text = string.Format(Resources.MailListAdmin.NotImportAlradyExistCount, existsMailsCount) + " <br />" + existsMails;
lblFailedMails.Text = string.Format(Resources.MailListAdmin.NotImportFailiarCount, failedMailsCount) + " <br />" + failedMails;
//---------------------------------------------------------------------------------------------
}
else
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.MailListAdmin.FileNotSupportedFile;
}
}
else
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.MailListAdmin.FileNotFound;
}
//--------------------------------------
}
//-----------------------------------------------
//btnSave_Click
//-----------------------------------------------
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
if (fuFile.HasFile)
{
try
{
string fileName = DCServer.MapPath(DCSiteUrls.GetPath_MailList_AttachmentDir() + fuFile.FileName);
fuFile.SaveAs(fileName);
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fileName + ";" + "Extended Properties=Excel 8.0;";
// Create connection object by using the preceding connection string.
OleDbConnection objConn = new OleDbConnection(sConnectionString);
// Open connection with the database.
objConn.Open();
// The code to follow uses a SQL SELECT command to display the data from the worksheet.
// Create new OleDbCommand to return data from worksheet.
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;
// Create new DataSet to hold information from the worksheet.
DataSet objDataset1 = new DataSet();
// Fill the DataSet with the information from the worksheet.
objAdapter1.Fill(objDataset1, "XLData");
//---------------------------------------------------------------------
ExecuteCommandStatus status;
int successfullyMailsCount = 0;
string existsMails = "";
int existsMailsCount = 0;
string failedMails = "";
int failedMailsCount = 0;
string notMails = "";
int notMailsCount = 0;
//---------------------------------------------------------------------
MailListUsersEntity mailUser = new MailListUsersEntity();
//---------------------------------------------------------------------
//props
//---------------------------------------------------------------------
Languages langID = (Languages)SiteSettings.Languages_DefaultLanguageID;
if (SiteSettings.Languages_HasMultiLanguages)
{
langID = (Languages)Convert.ToInt32(ddlLanguages.SelectedValue);
}
//------------------------------------------------
mailUser.LangID = langID;
//------------------------------------------------
if (SiteSettings.MailList_HasGroups)
{
mailUser.GroupID = Convert.ToInt32(ddlMailListGroups.SelectedValue);
mailUser.Groups = "#" + mailUser.GroupID + "#";
}
//------------------------------------------------
mailUser.ModuleTypeID = (int)StandardItemsModuleTypes.MailList;
//--------------------------------------
mailUser.IsActive = cbIsActive.Checked;
//--------------------------------------
bool isEmail = false;
string email = "";
//--------------------------------------
for (int i = 0; i < objDataset1.Tables[0].Rows.Count; i++)
{
isEmail = false;
email = objDataset1.Tables[0].Rows[i].ItemArray[0].ToString();
try
{
isEmail = DCValidation.IsEmail(email);
if (isEmail)
{
mailUser.Email = email;
status = MailListUsersFactory.Create(mailUser);
switch (status)
{
case ExecuteCommandStatus.Done:
++successfullyMailsCount;
break;
case ExecuteCommandStatus.AllreadyExists:
existsMails += email + "<br>";
++existsMailsCount;
break;
case ExecuteCommandStatus.UnknownError:
failedMails += email + "<br>";
++failedMailsCount;
break;
default:
failedMails += email + "<br>";
++failedMailsCount;
break;
}
}
else
{
notMails += email + "<br>";
++notMailsCount;
}
}
catch (Exception ex)
{
notMails += email + "<br>";
++notMailsCount;
}
}
objConn.Close();
//---------------------------------------------------------------------------------------------
lblSuccessfulyMails.Text = string.Format(Resources.MailListAdmin.ImportSuccessfulyCount, successfullyMailsCount);
lblNotMails.Text = string.Format(Resources.MailListAdmin.NotImportNotMailsCount, notMailsCount) + " <br />" + notMails;
lblExistsMails.Text = string.Format(Resources.MailListAdmin.NotImportAlradyExistCount, existsMailsCount) + " <br />" + existsMails;
lblFailedMails.Text = string.Format(Resources.MailListAdmin.NotImportFailiarCount, failedMailsCount) + " <br />" + failedMails;
//---------------------------------------------------------------------------------------------
//ClearControls();
}
catch (Exception ex)
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.MailListAdmin.FileNotSupportedFile;
}
}
else
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.MailListAdmin.FileNotFound;
}
}
