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;
}
}
