protected void dgAttachment_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName)
{
case "AEDelete":
try
{
int index = Convert.ToInt32(e.CommandArgument);
SAP_VendorAttachment obj = new SAP_VendorAttachment();
dgAttachment.SelectedIndex = index;
obj.Id = int.Parse(dgAttachment.SelectedValue.ToString());
db.SAP_VendorAttachment.Remove(obj);
db.SaveChanges();
dgAttachment.SelectedIndex = -1;
lblError.Text = "Record successfully deleted.";
BindAttachments(dgAttachment);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
break;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
public void Upload(UploadedFile fileUpload, string description, string userId, string userName)
{
try
{
if (fileUpload.ContentLength > 0)
{
var file = fileUpload;
if (description.Equals(""))
{
this.ErrorMessage = "Please enter file description.";
return;
}
SAP_VendorAttachment obj = new SAP_VendorAttachment();
//int iFileSize = file.ContentLength;
//if (iFileSize > 2000000) // 2MB approx (actually less though)
//{
// this.ErrorMessage = "File size should be less than 2 MB.";
// return;
//}
string path;
path = Server.MapPath("../");
string _folderPath = path + @"\Documents\" + this.RequestId;
DirectoryInfo _folder = new DirectoryInfo(_folderPath);
if (!_folder.Exists)
{
_folder.Create();
}
fileUpload.SaveAs(_folderPath + @"\" + fileUpload.FileName);
obj.RequestId = this.RequestId;
obj.FileName = fileUpload.FileName;
obj.UserId = userId;
obj.UserName = userName;
obj.Description = description;
obj.CreatedDate = DateTime.Now;
obj.Path = @"Documents/" + this.RequestId + @"/" + obj.FileName;
db.SAP_VendorAttachment.Add(obj);
db.SaveChanges();
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
protected void Attachments_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
SAP_VendorAttachment rowView = (SAP_VendorAttachment)e.Row.DataItem;
HyperLink lnk = (HyperLink)e.Row.FindControl("lnkAttachment");
lnk.Text = rowView.FileName;
string HttpFilePath = Request.ApplicationPath + @"/" + rowView.Path;
lnk.NavigateUrl = HttpFilePath;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
protected void Attachments_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
GridView gridView = sender as GridView;
switch (e.CommandName)
{
case "AEDelete":
try
{
int index = Convert.ToInt32(e.CommandArgument);
gridView.SelectedIndex = index;
int Id = (int)gridView.SelectedDataKey["Id"]; SAP_VendorAttachment obj = db.SAP_VendorAttachment.Where(d => d.Id == Id).FirstOrDefault();
if (obj != null)
{
if (this.UserId == obj.UserId)
{
db.SAP_VendorAttachment.Remove(obj);
db.SaveChanges();
gridView.SelectedIndex = -1;
this.ErrorMessage = "Record successfully deleted.";
BindAttachments(gridView);
}
else
{
this.ErrorMessage = "Not Allow.";
}
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
break;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
