protected void btnAddFile_Click(object sender, EventArgs e) { try { if (uploadList.HasFile) { //sFile = String.Format("{0}.{1}", DateTime.Now.ToFileTime(), uploadList.FileName); var ext = new System.IO.FileInfo(uploadList.FileName); var fileName = String.Format("{0}.{1}{2}", m_sPurchaseOrder, gridMaterialLists.Rows.Count + 1, ext.Extension); var sPath = String.Format("{0}/{1}/", Page.Server.MapPath("~/MaterialLists"), m_nProjectId); if (!System.IO.Directory.Exists(sPath)) { System.IO.Directory.CreateDirectory(sPath); } uploadList.SaveAs(sPath + fileName); // Add a new item to the list var nMax = from m in m_db.tMaterialLists orderby m.MaterialListNo descending where m.MaterialListProjectId == m_nProjectId select m.MaterialListNo; Int32 n = 1; if (nMax != null && nMax.Count() > 0) { n = nMax.Max() + 1; } tMaterialList ml = new tMaterialList { MaterialListDescription = fileName, MaterialListFileName = fileName, MaterialListFilePath = String.Format("{0}/{1}", m_nProjectId, fileName.Trim()), MaterialListProjectId = m_nProjectId, MaterialListPurchaseId = m_nPurchaseId, MaterialListSatisfied = false, MaterialListNo = n }; m_db.tMaterialLists.InsertOnSubmit(ml); m_db.SubmitChanges(); gridMaterialLists.DataBind(); } } catch (Exception ex) { Response.Write(ex.Message); } }
protected void btnAddFile_Click(object sender, EventArgs e) { try { String sFile; String sPath; if (uploadList.HasFile) { sFile = String.Format("{0}.{1}", DateTime.Now.ToFileTime(), uploadList.FileName); sPath = String.Format("{0}/", Page.Server.MapPath("~/MaterialLists")); uploadList.SaveAs(sPath + sFile); // Add a new item to the list var nMax = from m in m_db.tMaterialLists orderby m.MaterialListNo descending where m.MaterialListProjectId == m_nProjectId select m.MaterialListNo; Int32 n = 1; if (nMax != null && nMax.Count() > 0) { n = nMax.Max() + 1; } tMaterialList ml = new tMaterialList { MaterialListDescription = uploadList.FileName, MaterialListFileName = uploadList.FileName, MaterialListFilePath = sFile.Trim(), MaterialListProjectId = m_nProjectId, MaterialListSatisfied = false, MaterialListNo = n }; m_db.tMaterialLists.InsertOnSubmit(ml); m_db.SubmitChanges(); gridMaterialLists.DataBind(); } } catch (Exception ex) { lblError.Text = ex.Message; } }