Question 85976 in ASP.NET Question posted in
The official documentation can be found here.

Filename overwrites the uploaded attachments – Asp.net

The file name is generated by Po+Invoice in the sql table. When user attach a pdf it overwrites the existing file name that has same po+invoice. Is there anyway i could create the unique id filename.

public partial class upload : System.Web.UI.Page
{
    string mID;

    DataBaseDataContext dataBaseDataContext = new DataBaseDataContext();
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    protected void btnExit_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }

    protected void SUbmit(object sender, EventArgs e)
    {
        try
        {
            var ext = FileUploadtoServer.FileName.Substring(FileUploadtoServer.FileName.IndexOf('.') + 1, 3);
            if (ext.ToLower() != "pdf")
            {
                Response.Write("<script>alert('Please select a pdf File!')</script>");
                return;
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('Please select a pdf File!')</script>");
            return;
        }

        if (PO_Number.Text.Equals("") || HeadCode.Text.Equals("") || Manufacture.Text.Equals("") || Description.Text.Equals("") || Invoice.Text.Equals(""))
        {
            Response.Write("<script>alert('Please Fill All Fields!')</script>");
        }

        TPT tPT = new TPT();
        tPT.Invoice_No = Invoice.Text;
        tPT.PO_Number = PO_Number.Text;
        tPT.Item_Code = Manufacture.Text;
        tPT.Heat_Code = HeadCode.Text;
        tPT.Description = Description.Text;
        tPT.FileName = PO_Number.Text + Invoice.Text + ".pdf";
        dataBaseDataContext.TPTs.InsertOnSubmit(TPT);
        dataBaseDataContext.SubmitChanges();

        String path = Server.MapPath("Attachments/" + PO_Number.Text + Invoice.Text + ".pdf");
        FileUploadtoServer.SaveAs(path);
        Response.Write("<script>alert('Successfully Inserted!')</script>");
        Invoice.Text = "";
        Manufacture.Text = "";
        HeadCode.Text = "";
        Description.Text = "";
        PO_Number.Text = "";
    }
}

I have tried

Guid.NewGuid() + ".pdf";,

it still does the same thing.

Tags:

2

Answers


  1. 0

    The simple way would be to just take the file name, and add -1, then -2, then -3

    So,

       mydoc.pdf
   mydoc-1.pdf
   mydoc-2.pdf
   etc. etc.

    So, then say a function like this:

    Edit: Updated code

    string GetServerFilenext(string strFileFullPath)
{
    string strFileToCheck = "";
    for (int i = 0; i < 100; i++)
    {
        if (i == 0)
            strFileToCheck = strFileFullPath;
        else
            strFileToCheck =
                Path.GetDirectoryName(strFileFullPath) + 
                @"" + Path.GetFileNameWithoutExtension(strFileFullPath) +
                "-" + i.ToString() + Path.GetExtension(strFileFullPath);

        if (!File.Exists(strFileToCheck))
            break;
    }
    return strFileToCheck;
}

    So, now your code becomes this:

     string sFileToSave = 
       Server.MapPath(@"~/Attachments/" + PO_Number.Text + Invoice.Text + ".pdf");

 sFileToSave = GetServerFileNext(sFileToSave);

 tPT.FileName = Path.GetFileName(sFiletoSave);

    So, you setup the full path and file name.

    You then check if it exists, and if not, then add -1, then -2 etc. etc.

    Edit2: So, code would look like this (warning: air code)

            string sFileToSave =
            Server.MapPath(@"~/Attachments/" + PO_Number.Text + Invoice.Text + ".pdf");

        sFileToSave = GetServerFileNext(sFileToSave);

        TPT tPT = new TPT();
        tPT.Invoice_No = Invoice.Text;
        tPT.PO_Number = PO_Number.Text;
        tPT.Item_Code = Manufacture.Text;
        tPT.Heat_Code = HeadCode.Text;
        tPT.Description = Description.Text;
        tPT.FileName = Path.GetFileName(sFileToSave);
        dataBaseDataContext.TPTs.InsertOnSubmit(TPT);
        dataBaseDataContext.SubmitChanges();

        FileUploadtoServer.SaveAs(sFileToSave);
    Login or Signup to reply.
  2. 0

    Instead of adding -1,-2, i was able to upload it by adding date stamp

    `tPT.FileName = PO_Number.Text + Invoice.Text + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf";`
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search