public JsonResult ManageSiteTaskInventory(string Filter, List <PM_SiteTaskInventory> STI_List, long SiteTaskId, long SiteId, long UserId)
{
PM_TaskEntryBL te = new PM_TaskEntryBL();
dbDataTable ddt = new dbDataTable();
DataTable dt = ddt.List();
foreach (var item in STI_List)
{
myDataTable.AddRow(dt, "Value1", item.SiteTaskId, "Value2", item.CategoryId, "Value3", item.SiteId, "Value4", item.SiteTaskInventoryId, "Value5", item.IsModified, "Value6", item.ItemId, "Value7", item.Quantity, "Value8", item.BarCode, "Value11", item.Description);
}
DataTable res = te.Manage_SiteTask_Inventory(Filter, dt, SiteTaskId, SiteId, UserId);
// Update Attachments Directory
if (res.Rows.Count > 0)
{
for (int i = 0; i < res.Rows.Count; i++)
{
var ExistingPath = res.Rows[i]["SubDirectory"].ToString();
var NewPath = res.Rows[i]["InventoryId"].ToString();
SWI.AirView.Common.WebConfig wc = new SWI.AirView.Common.WebConfig();
var SiteTaskInventoryPath = wc.AppSettings("SiteTaskInventoryPath");
var path = Path.Combine(Server.MapPath("~/" + SiteTaskInventoryPath + "/" + ExistingPath));
string pathString = System.IO.Path.Combine(path.ToString());
bool isExists = System.IO.Directory.Exists(pathString);
string NewPathString = (Path.Combine(Server.MapPath("~/" + SiteTaskInventoryPath + "/" + NewPath))).ToString();
if (isExists)
{
System.IO.Directory.Move(pathString, NewPathString);
}
}
}
Response response = new Response();
try
{
response.Status = "success";
response.Message = "Save successfully";
}
catch (Exception ex)
{
response.Status = "danger";
response.Message = ex.Message;
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
public JsonResult RemoveSiteTaskInventory(string Filter, int SiteTaskInventoryId, long CategoryId, long ItemId, string FileName)
{
PM_TaskEntryBL te = new PM_TaskEntryBL();
try
{
if (Filter == "DeleteAttachmentById")
{
SWI.AirView.Common.WebConfig wc = new SWI.AirView.Common.WebConfig();
var SiteTaskInventoryPath = wc.AppSettings("SiteTaskInventoryPath");
var SubDirectory = "";
if (SiteTaskInventoryId != 0)
{
SubDirectory = SiteTaskInventoryId.ToString();
}
else
{
SubDirectory = (CategoryId + "_" + ItemId).ToString();
}
var path = Path.Combine(Server.MapPath("~/" + SiteTaskInventoryPath + "/" + SubDirectory));
try
{
if ((System.IO.File.Exists(path + "/" + FileName)))
{
System.IO.File.Delete(path + "/" + FileName);
}
System.IO.DirectoryInfo di = new DirectoryInfo(path);
if (di.GetFiles().Length == 0)
{
System.IO.Directory.Delete(path, true);
}
}
catch {}
te.Manage_SiteTask_Inventory("DeleteAttachmentById", null, 0, 0, 0, SiteTaskInventoryId, FileName, SubDirectory, 0);
}
else
{
SWI.AirView.Common.WebConfig wc = new SWI.AirView.Common.WebConfig();
var SiteTaskInventoryPath = wc.AppSettings("SiteTaskInventoryPath");
var SubDirectory = "";
if (SiteTaskInventoryId != 0)
{
SubDirectory = SiteTaskInventoryId.ToString();
}
else
{
SubDirectory = (CategoryId + "_" + ItemId).ToString();
}
var path = Path.Combine(Server.MapPath("~/" + SiteTaskInventoryPath + "/" + SubDirectory));
try
{
if (System.IO.Directory.Exists(path))
{
System.IO.DirectoryInfo di = new DirectoryInfo(path);
foreach (FileInfo file in di.GetFiles())
{
file.Delete();
}
System.IO.Directory.Delete(path, true);
}
}
catch { }
te.Manage_SiteTask_Inventory("DeleteSiteTaskInventory", null, 0, 0, 0, SiteTaskInventoryId, FileName, SubDirectory, 0);
}
}
catch
{
}
Response res = new Response()
{
Message = "Removed!",
Status = "success"
};
return(Json(res, JsonRequestBehavior.AllowGet));
}
public ActionResult UploadAttachments(int SiteTaskInventoryId, long CategoryId, long ItemId)
{
PM_TaskEntryBL te = new PM_TaskEntryBL();
bool isSavedSuccessfully = true;
string fName = "";
string SubDirectory = "";
try
{
foreach (string fileName in Request.Files)
{
HttpPostedFileBase file = Request.Files[fileName];
fName = file.FileName;
if (file != null && file.ContentLength > 0)
{
SWI.AirView.Common.WebConfig wc = new SWI.AirView.Common.WebConfig();
var SiteTaskInventoryPath = wc.AppSettings("SiteTaskInventoryPath");
if (SiteTaskInventoryId == 0)
{
SubDirectory = (CategoryId + "_" + ItemId).ToString();
}
else
{
SubDirectory = SiteTaskInventoryId.ToString();
}
var path = Path.Combine(Server.MapPath("~/" + SiteTaskInventoryPath + "/" + SubDirectory));
string pathString = System.IO.Path.Combine(path.ToString());
var fileName1 = Path.GetFileName(file.FileName);
bool isExists = System.IO.Directory.Exists(pathString);
if (!isExists)
{
System.IO.Directory.CreateDirectory(pathString);
}
var uploadpath = string.Format("{0}\\{1}", pathString, file.FileName);
file.SaveAs(uploadpath);
DataTable res = te.Manage_SiteTask_Inventory("Add_Attachments", null, 0, 0, 0, SiteTaskInventoryId, file.FileName, SubDirectory, file.ContentLength);
if (res.Rows.Count == 0)
{
isSavedSuccessfully = false;
}
}
}
}
catch (Exception ex)
{
isSavedSuccessfully = false;
}
if (isSavedSuccessfully)
{
return(Json(new
{
Message = fName
}));
}
else
{
return(Json(new
{
Message = "Error in saving file"
}));
}
}
