public void SendEmail(UserMail userLogin, UserMail usermail, string strSubject, string strBody)
{
List<UserMail> listUserMailTO = new List<UserMail>();
if(userLogin!=null)
listUserMailTO.Add(userLogin);
listUserMailTO.Add(usermail);
SendEmail(listUserMailTO, null, strSubject, strBody, null);
}
public void SendmailToAdmin()
{
List<UserMail> listMailAdmin = new List<UserMail>();
UserMail userMail = null;
string permission = "1";
string admin="admin";
if (admin.ToLower() == "admin")
{
using (SqlConnection Conn = new SqlConnection(Common.GetConnectString()))
{
using (SqlCommand cmd = new SqlCommand("DDV_GetAccountAdmin", Conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@account", admin);
Conn.Open();
var accountAdmin = cmd.ExecuteScalar();
Conn.Close();
if (accountAdmin != null)
{
userMail= new UserMail(admin, admin, accountAdmin.ToString());
string subject = Common.GetResourceString("AccountRegister");
string mailBody = GetMailBody("Notify_mail_register.txt");
listMailAdmin.Add(userMail);
foreach (UserMail mail in listMailAdmin)
{
mail.SendEmail(userMail, mail, subject, mailBody);
}
}
}
}
}
else
{
using (SqlConnection Conn = new SqlConnection(Common.GetConnectString()))
{
using (SqlCommand cmd = new SqlCommand("DDV_GetEmailAdmin", Conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@permission", permission);
Conn.Open();
var emailAdmin = cmd.ExecuteScalar();
Conn.Close();
if (emailAdmin != null)
{
userMail = new UserMail(permission, permission, emailAdmin.ToString());
string subject = Common.GetResourceString("AccountRegister");
string mailBody = GetMailBody("Notify_mail_register.txt");
listMailAdmin.Add(userMail);
foreach (UserMail mail in listMailAdmin)
{
mail.SendEmail(userMail, mail, subject, mailBody);
}
}
}
}
}
}
/// <summary>
/// Upload............
/// </summary>
/// <param name="dicPostedFiles"></param>
private void StartUpload(Dictionary<string, HttpPostedFile> dicPostedFiles)
{
string EmailCustomer = "";
string EmailMember = "";
string listName = "";
#region Upload file
if (Common.AppSettingKey(Constant.STORAGE_CONNECT_STRING) != "")
{
BlobManager blobManager = new BlobManager();
foreach (string fileName in dicPostedFiles.Keys)
{
HttpPostedFile postedFile = dicPostedFiles[fileName];
long ContentLength = 0;
if (postedFile == null)
{
ContentLength = blobManager.CopyBlob("Temp/" + HiddenFieldAccount.Value + "/" + fileName, LabelCustomerName.Text + "/" + fileName);
}
else
{
ContentLength = postedFile.ContentLength;
blobManager.UploadFromStream(postedFile.InputStream, LabelCustomerName.Text + "/" + fileName);
}
listName += fileName + ", ";
FileInfoMation obj = new FileInfoMation();
obj.File_Sharing_ID = HiddenFieldID.Value;
obj.File_Name = Path.GetFileName(fileName);
obj.File_Size = ContentLength.ToString();
obj.Upload_Date = DateTime.Now.ToString();
FileInforMa.File_Insert(obj);
}
}
else
{
foreach (HttpPostedFile postedFile in dicPostedFiles.Values)
{
CreateFolder();
string directoryPath = Server.MapPath("~/" + Constant.UPLOAD_STORAGE + "\\" + LabelCustomerName.Text.Trim());
postedFile.SaveAs(directoryPath + "\\" + Path.GetFileName(postedFile.FileName));
listName += Path.GetFileName(postedFile.FileName) + ", ";
FileInfoMation obj = new FileInfoMation();
obj.File_Sharing_ID = HiddenFieldID.Value;
obj.File_Name = Path.GetFileName(postedFile.FileName);
obj.File_Size = postedFile.ContentLength.ToString();
obj.Upload_Date = DateTime.Now.ToString();
FileInforMa.File_Insert(obj);
}
}
#endregion
#region SendMail
if (!string.IsNullOrEmpty(listName))
{
listName = listName.Remove(listName.Length - 2);
///// send mail customer
List<CustomerInfo> listCustomer = new List<CustomerInfo>();
listCustomer = CustomerCallControl.File_GetByAll();
listCustomer = listCustomer.Where(c => c.File_Sharing_ID == HiddenFieldID.Value).ToList();
EmailCustomer = listCustomer[0].CustomerEmail;
UserMail mailSystemCus = new UserMail(HiddenFieldAccount.Value, HiddenFieldAccount.Value, EmailCustomer);
mailSystemCus.AddParams("{FileName}", listName);
string mailBody = GetMailBody("Alert_mail_upload.txt");
mailSystemCus.SendEmail(mailSystemCus, Common.GetResourceString("MAIL_UploadSubject"), mailBody);
///// send mail member
List<DDMemberInfoCustomer> listMemberAccount = new List<DDMemberInfoCustomer>();
listMemberAccount = DDMemberCallControlCustomer.File_GetByAll();
listMemberAccount = listMemberAccount.Where(c => c.Account == HiddenFieldAccount.Value).ToList();
EmailMember = listMemberAccount[0].Email;
UserMail mailSystemMem = new UserMail(HiddenFieldAccount.Value, HiddenFieldAccount.Value, EmailMember);
mailSystemMem.AddParams("{FileName}", listName);
mailSystemMem.SendEmail(mailSystemMem, Common.GetResourceString("MAIL_UploadSubject"), mailBody);
PostedFiles = new Dictionary<string, HttpPostedFile>();
RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_SUCESS"), GetResource("MSG_UPLOAD_SUCESS")) + "\");");
}
else
throw new Exception(GetResource("MSG_AT_LEAST_ONE_CUSTOMER"));
#endregion
}
/// <summary>
/// Download Azure
/// </summary>
protected void DownloadAzure()
{
string fileName = "";
string listName = "";
List<String> names = new List<String>();
string Email = "";
ZipFile zip = new ZipFile();
// Get Name
for (int i = 0; i < CheckBoxListFile.Items.Count; i++)
{
if (CheckBoxListFile.Items[i].Selected)
{
fileName = CheckBoxListFile.Items[i].ToString();
listName += fileName + ", ";
names.Add(fileName);
}
}
//Send Mail And download
if (!string.IsNullOrEmpty(listName))
{
//Send Mail
try
{
List<DDMemberInfoCustomer> listMemberAccount = new List<DDMemberInfoCustomer>();
listMemberAccount = DDMemberCallControlCustomer.File_GetByAll();
listMemberAccount = listMemberAccount.Where(c => c.Account == HiddenFieldAcount.Value).ToList();
Email = listMemberAccount[0].Email;
UserMail mailSystem = new UserMail(HiddenFieldAcount.Value, HiddenFieldAcount.Value, Email);
var listNamenew = listName.Remove(listName.Length - 2);
mailSystem.AddParams("{FileName}", listNamenew);
string mailBody = GetMailBody("Alert_mail_download.txt");
mailSystem.SendEmail(mailSystem, Common.GetResourceString("MAIL_DownloadSubject"), mailBody);
}
catch
{
}
// Download
BlobManager blobManager = new BlobManager();
foreach (string namenew in names)
{
WebClient client = new WebClient();
var s = client.OpenRead(blobManager.GetURi(LabelCustomerName.Text + "/" + namenew));
zip.MaxOutputSegmentSize = 1024 * 1024 * 1024;
zip.AddEntry(namenew, s);
}
ButtonDownload.Enabled = true;
Response.Clear();
Response.Buffer = false;
Response.BufferOutput = false;
Response.ContentType = "application/zip";
if (names.Count > 1)
Response.AddHeader("Content-Disposition", "attachment; filename=" + LabelCustomerName.Text + GetResource("All_Files") + ".zip");
else
{
fileName = fileName.Remove(fileName.Length - 4);
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".zip");
}
Response.Flush();
zip.Save(Response.OutputStream);
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + GetResource("MSG_AT_LEST_ONE_FILE_DOWNLOAD") + "');", true);
return;
}
}
/// <summary>
/// Download webserver
/// </summary>
protected void DownloadWebServer()
{
string fileName = "";
string filePath = "";
string listName = "";
List<String> names = new List<String>();
string Email = "";
string customerFoler = "";
ZipFile zip = new ZipFile();
//Get name
customerFoler = Server.MapPath("~/" + Constant.UPLOAD_STORAGE) + "\\" + LabelCustomerName.Text;
for (int i = 0; i < CheckBoxListFile.Items.Count; i++)
{
if (CheckBoxListFile.Items[i].Selected)
{
fileName = CheckBoxListFile.Items[i].ToString();
listName += fileName + ", ";
names.Add(fileName);
}
}
// Send Mail and download
if (!string.IsNullOrEmpty(listName))
{
//Send Mail
List<DDMemberInfoCustomer> listMemberAccount = new List<DDMemberInfoCustomer>();
listMemberAccount = DDMemberCallControlCustomer.File_GetByAll();
listMemberAccount = listMemberAccount.Where(c => c.Account == HiddenFieldAcount.Value).ToList();
Email = listMemberAccount[0].Email;
UserMail mailSystem = new UserMail("A", "A", Email);
listName = listName.Remove(listName.Length - 2);
mailSystem.AddParams("{FileName}", listName);
string mailBody = GetMailBody("Alert_mail_download.txt");
mailSystem.SendEmail(mailSystem, "Download Notice", mailBody);
//Zip file
foreach(string namenew in names)
{
filePath = string.Format("{0}\\{1}", customerFoler, namenew);
if (!File.Exists(filePath))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + GetResource("MSG_FILE_DOWNLOAD_FOUND") + "');", true);
return;
}
else if(names.Count > 1)
zip.AddFile(filePath, LabelCustomerName.Text + GetResource("All_Files"));
else
zip.AddFile(filePath, namenew);
}
//Download
ButtonDownload.Enabled = true;
logger.Info("start");
Response.Clear();
Response.BufferOutput = false;
Response.ContentType = "application/zip";
if (names.Count > 1)
Response.AddHeader("Content-Disposition", "attachment; filename=" + LabelCustomerName.Text + GetResource("All_Files") + ".zip");
else
{
fileName = fileName.Remove(fileName.Length - 4);
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".zip");
}
zip.Save(Response.OutputStream);
Response.End();
logger.Info("end");
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + GetResource("MSG_AT_LEST_ONE_FILE_DOWNLOAD") + "');", true);
return;
}
}
protected void downloadFile(string fName)
{
try
{
string fileName = "";
string filePath = "";
string listName = "";
List<String> names = new List<String>();
string Email = "";
ZipFile zip = new ZipFile();
if (fName == null)
{
foreach (GridViewRow row in fileGrid.Rows)
{
fileName = row.Cells[2].Text;
listName += fileName + ", ";
names.Add(fileName);
}
}
else
{
fileName = fName;
listName += fileName + ", ";
names.Add(fileName);
}
#region User Azure
if (Common.AppSettingKey(Constant.STORAGE_CONNECT_STRING) != "")
{
// Send Mail
foreach( GridViewRow row in gridCustomers.Rows)
{
Email = row.Cells[1].Text;
}
UserMail mailSystem = new UserMail("A", "A", Email);
var listNamenew = listName.Remove(listName.Length - 2);
mailSystem.AddParams("{FileName}", listNamenew);
string mailBody = GetMailBody("Alert_mail_download.txt");
mailSystem.SendEmail(mailSystem, "Download Notice", mailBody);
// Download
BlobManager blobManager = new BlobManager();
foreach (string namenew in names)
{
WebClient client = new WebClient();
var s = client.OpenRead(blobManager.GetURi(LabelCustomerName.Text + "/" + namenew));
zip.AddEntry(namenew, s);
}
Response.Clear();
Response.ContentType = "application/zip";
if(names.Count > 1)
Response.AddHeader("Content-Disposition", "attachment; filename=" + LabelCustomerName.Text + GetResource("All_Files") + ".zip");
else
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".zip");
zip.Save(Response.OutputStream);
Response.End();
}
#endregion
#region User WebServer
else
{
string customerFoler = Server.MapPath("~/" + Constant.UPLOAD_STORAGE) + "\\" + LabelCustomerName.Text;
foreach(string NameNew in names)
{
filePath = string.Format("{0}\\{1}", customerFoler, NameNew);
if (!File.Exists(filePath))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + GetResource("MSG_FILE_DOWNLOAD_FOUND") + "');", true);
return;
}
if (names.Count > 1)
zip.AddFile(filePath, LabelCustomerName.Text + GetResource("All_Files"));
else
zip.AddFile(filePath, NameNew);
}
if (!string.IsNullOrEmpty(listName))
{
foreach (GridViewRow row in gridCustomers.Rows)
{
Email += row.Cells[1].Text + ";";
}
Email = Email.Substring(0, Email.Length - 1);
UserMail mailSystem = new UserMail("A", "A", Email);
listName = listName.Remove(listName.Length - 2);
mailSystem.AddParams("{FileName}", listName);
string mailBody = GetMailBody("Alert_mail_download.txt");
mailSystem.SendEmail(mailSystem, "Download Notice", mailBody);
Response.Clear();
Response.ContentType = "application/zip";
if(names.Count > 1)
Response.AddHeader("Content-Disposition", "attachment; filename=" + LabelCustomerName.Text + GetResource("All_Files") + ".zip");
else
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".zip");
zip.Save(Response.OutputStream);
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + GetResource("MSG_AT_LEST_ONE_FILE_DOWNLOAD") + "');", true);
return;
}
}
#endregion
}
catch (Exception ex)
{
RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_ERROR"), ex.Message) + "\");");
return ;
}
}
private void UpdateMember()
{
using (SqlConnection Conn = new SqlConnection(Common.GetConnectString()))
{
try
{
string memberMail = txtEmail.Text;
List<UserMail> listMember = new List<UserMail>();
UserMail accountMailActivated = null;
Conn.Open();
using (SqlCommand cmd = new SqlCommand("DDV_UpdateMember", Conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@account", txtAccount.Text);
cmd.Parameters.AddWithValue("@name", txtName.Text);
cmd.Parameters.AddWithValue("@email", txtEmail.Text);
cmd.Parameters.AddWithValue("@permission", DropDownListAdmin.SelectedItem.Value.ToString());
var result = (int)cmd.ExecuteNonQuery();
Conn.Close();
if (result > 0)
{
accountMailActivated = new UserMail(txtAccount.Text, txtName.Text, memberMail);
PanelGridManager.Visible = true;
PanelMember.Visible = false;
if (DropDownListAdmin.SelectedValue != null)
{
string subject = Common.GetResourceString("ActivatedAccount");
string mailBody = GetMailBody("Notify_account_activated.txt");
listMember.Add(accountMailActivated);
foreach (UserMail mail in listMember)
{
mail.SendEmail(accountMailActivated, mail,subject, mailBody);
}
}
}
else
{
RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_ERROR"), GetResource("UpdateFail")) + "\");");
}
}
}
catch (SqlException ex)
{
LabelMessage.Text = ex.Message;
logger.Error("Button update account error ", ex);
}
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
string userLogin = hiddenAccount.Value;
logger.Info("Begin btnUpload_Click userLogin = "******"0" : "1";
DateTime expireDate = DateTime.Now.Date.AddDays(Convert.ToInt32(dropdownTermUpload.SelectedValue));
//1. check Customer list
if (this.CustomerInfo.Count == 0)
throw new Exception(GetResource("MSG_AT_LEAST_ONE_CUSTOMER"));
//1.2 Check At least ONE upload file
if (panelUploadFiles.Visible == false || PostedFiles.Count == 0)
throw new Exception(GetResource("MSG_AT_LEST_ONE_FILE_UPLOAD"));
//2.Update Database
string hostPath = GetMapPath();
List<UserMail> listMailSystem = new List<UserMail>();
using (SqlConnection Conn = new SqlConnection(Common.GetConnectString()))
{
SqlTransaction Trans = null;
try
{
Conn.Open();
UserMail accountMailLogin = null;
using (SqlCommand cmd = new SqlCommand("DDV_GetDDMemberEmail", Conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Account", userLogin);
var emailAdress = cmd.ExecuteScalar();
if (emailAdress != null)
accountMailLogin = new UserMail(userLogin, userLogin, emailAdress.ToString());
}
logger.Debug("Begin Transaction for update db");
Trans = Conn.BeginTransaction();
#region Update Database , files
foreach (CustomerInfo customer in this.CustomerInfo)
{
customer.CustomerId = KeyGenerator.GetUniqueKey(20);
string customerPass = KeyGenerator.GetUniqueKey(10);
string fileSharingId = "";
using (SqlCommand cmd = new SqlCommand("DDV_InsertSharingInfo", Conn, Trans))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@dd_member_account", userLogin);
cmd.Parameters.AddWithValue("@Mode_code", modeCode);
cmd.Parameters.AddWithValue("@customer_id", customer.CustomerId);
cmd.Parameters.AddWithValue("@customer_password", customerPass);
cmd.Parameters.AddWithValue("@expiration_date", expireDate);
cmd.ExecuteNonQuery();
fileSharingId = cmd.Parameters["@id"].Value.ToString();
}
using (SqlCommand cmd = new SqlCommand("DDV_InsertCustomerInfo", Conn, Trans))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@File_Sharing_ID", fileSharingId);
cmd.Parameters.AddWithValue("@Customer_name", customer.CustomerName);
cmd.Parameters.AddWithValue("@Customer_Email", customer.CustomerEmail);
cmd.ExecuteNonQuery();
}
//Case Upload File
string listFileName = "";
if (panelUploadFiles.Visible)
{
logger.Debug("Upload files in customerID = " + customer.CustomerId);
if (Common.AppSettingKey(Constant.STORAGE_CONNECT_STRING) != "")
{
BlobManager blobManager = new BlobManager();
foreach (DetailsFile objfile in PostedFiles)
{
string blobName = customer.CustomerId + "/" + objfile.FileName;
string soureBlob = "Temp/" + hiddenAccount.Value + "/" + objfile.FileName;
long contentLenght = blobManager.CopyBlob(soureBlob, blobName);
if (contentLenght > 0)
{
listFileName += objfile.FileName + ",";
using (SqlCommand cmd = new SqlCommand("DDV_InsertFileInfo", Conn, Trans))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@File_Sharing_ID", fileSharingId);
cmd.Parameters.AddWithValue("@File_Name", Path.GetFileName(objfile.FileName));
cmd.Parameters.AddWithValue("@File_Size", objfile.ContentLength);
cmd.Parameters.AddWithValue("@Upload_Date", DateTime.Now.Date);
cmd.ExecuteNonQuery();
}
}
}
}
else
{
string pathCustomerID = CreateUploadCustomerID(hostPath, customer.CustomerId);
foreach (DetailsFile postedFile in PostedFiles)
{
listFileName += postedFile.FileName + "\n";
using (SqlCommand cmd = new SqlCommand("DDV_InsertFileInfo", Conn, Trans))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@File_Sharing_ID", fileSharingId);
cmd.Parameters.AddWithValue("@File_Name", postedFile.FileName);
cmd.Parameters.AddWithValue("@File_Size", postedFile.ContentLength);
cmd.Parameters.AddWithValue("@Upload_Date", DateTime.Now.Date);
cmd.ExecuteNonQuery();
}
}
}
}
//Add Mail System
UserMail mailSystem = new UserMail(customer.CustomerName, customer.CustomerName, customer.CustomerEmail);
mailSystem.AddParams("{DD_MEMBER_NAME}", userLogin);
mailSystem.AddParams("{customer_id}", customer.CustomerId);
mailSystem.AddParams("{customer_Password}", customerPass);
mailSystem.AddParams("{TD_FILE_SHARING_INFORATION.ID}", fileSharingId);
mailSystem.AddParams("{TD_FILE_SHARING_INFORMATION.Expiration_date}", expireDate.ToShortDateString());
mailSystem.AddParams("{UrlPortal}", Common.AppSettingKey(Constant.PORTAL_URL));
if (listFileName.Length > 0)
mailSystem.AddParams("{File_Name}", listFileName.Remove(listFileName.Length - 1, 1));
listMailSystem.Add(mailSystem);
}
Trans.Commit();
Conn.Close();
PostedFiles = null;
#endregion
#region SendMail
logger.Debug("Begin send Email ");
string mailBody = "";
string subject = "";
if (panelUploadFiles.Visible)
{
mailBody = GetMailBody(hostPath, "Invitation_mail_body_download.txt");
subject = Common.GetResourceString("MAIL_DownloadSubject");
}
else
{
mailBody = GetMailBody(hostPath, "Invitation_mail_body_upload.txt");
subject = Common.GetResourceString("MAIL_InvitationSubject");
}
foreach (UserMail mail in listMailSystem)
{
mail.SendEmail(accountMailLogin, mail, subject, mailBody);
}
#endregion
}
catch (Exception ex)
{
Trans.Rollback();
Conn.Close();
try
{
if (Common.AppSettingKey(Constant.STORAGE_CONNECT_STRING) != "")
{
BlobManager blobManager = new BlobManager();
foreach (CustomerInfo customer in this.CustomerInfo)
{
blobManager.DeleteBlobDirectory(customer.CustomerId);
}
}
else
{
foreach (CustomerInfo customer in this.CustomerInfo)
{
string pathCustomerID = System.IO.Path.Combine(hostPath, Constant.UPLOAD_STORAGE + "\\" + customer.CustomerId);
if (Directory.Exists(pathCustomerID))
Directory.Delete(pathCustomerID, true);
}
}
}
catch { logger.Error("Error when try to delete storage", ex); }
throw ex;
}
}
logger.Debug("End btnUpload_Click , loadData()");
ScriptManager.RegisterStartupScript(this, typeof(Page), "Redirect", "alert(\"" + GetJSMessage(GetResource("TITLE_SUCESS"), GetResource("MSG_UPLOAD_SUCESS")) + "\");window.location='Upload.aspx';", true);
}
catch (Exception ex)
{
ButtonUpload.Enabled = true;
logger.Error("Error btnUpload_Click", ex);
RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_ERROR"), ex.Message) + "\");");
}
}
