/// <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
}
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) + "\");");
}
}