public static List<WOTemplateFileDetails> GetDocumentFiles(string @FileIds)
{
var data = new List<WOTemplateFileDetails>();
tempinfo objtempinfo = new tempinfo();
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@FileIds", @FileIds);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetDocumentFiles]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var Template = new WOTemplateFileDetails();
FetchTemplate(Template, safe);
data.Add(Template);
}
return data;
}
/// <summary>
/// Description : Method is used to Insert new template details.
/// Created By : Sudheer
/// Created Date : 26th Aug 2014
/// Modified By : Sudheer
/// <returns></returns>
/// </summary>
public static int InsertTemplateFileDetails(WOTemplateFileDetails arrFilesList, string flag, string fieldID, string CreatedBy)
{
int result = 0;
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[12];
sqlParams[0] = new SqlParameter("@SetID", Convert.ToInt32(arrFilesList.SetID));
sqlParams[1] = new SqlParameter("@DisplayName", arrFilesList.DisplayName);
sqlParams[2] = new SqlParameter("@FileName", arrFilesList.FileName);
sqlParams[3] = new SqlParameter("@FilePath", arrFilesList.FilePath);
sqlParams[4] = new SqlParameter("@Description", arrFilesList.Description);
sqlParams[5] = new SqlParameter("@Status", Convert.ToBoolean(arrFilesList.Status));
sqlParams[6] = new SqlParameter("@IsDefault", Convert.ToBoolean(arrFilesList.IsDefault));
sqlParams[7] = new SqlParameter("@IsMultiple", Convert.ToBoolean(arrFilesList.IsMultiple));
sqlParams[8] = new SqlParameter("@MultipleEntity", arrFilesList.MultipleEntity);
sqlParams[9] = new SqlParameter("@Flag", flag);
sqlParams[10] = new SqlParameter("@FieldID", fieldID);
sqlParams[11] = new SqlParameter("@CreatedBy", CreatedBy);
result = SqlHelper.ExecuteNonQuery(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpInsertTemplateFileDetails", sqlParams);
}
catch (Exception ex)
{
log.Error("Error: " + ex);
}
log.Debug("End: " + methodBase.Name);
return result;
}
public static WOTemplateFileDetails FetchTemplate(WOTemplateFileDetails TMapping, SafeDataReader dr)
{
TMapping.FileName = dr.GetString("FileName");
TMapping.FilePath = dr.GetString("FilePath");
TMapping.IsDefault = dr.GetBoolean("IsDefault");
TMapping.IsMultiple = dr.GetBoolean("IsMultiple");
TMapping.MultipleEntity = dr.GetString("MultipleEntity");
return TMapping;
}
public ActionResult FileUpload(string Type, string Category, string TemplateDetails)
{
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
if (UserLogin.ValidateUserRequest())
{
return RedirectToAction("Login", "Home", new { area = "" });
}
string UserIDSession = Convert.ToString(System.Web.HttpContext.Current.Session["UserID"]);
var json_serializer = new JavaScriptSerializer();
Dictionary<string, object> routes_list = (Dictionary<string, object>)json_serializer.DeserializeObject(TemplateDetails);
Dictionary<string, object> a = (Dictionary<string, object>)routes_list["TemplateDetails"];
WOTemplateFileDetails arrFilesList = new WOTemplateFileDetails();
arrFilesList.SetID = Convert.ToString(a["SetID"]);
arrFilesList.DisplayName = Convert.ToString(a["DisplayName"]);
arrFilesList.FilePath = Convert.ToString(a["FilePath"]);
arrFilesList.Description = Convert.ToString(a["Description"]);
arrFilesList.Status = Convert.ToString(a["Status"]);
arrFilesList.IsDefault = Convert.ToBoolean(a["IsDefault"]);
arrFilesList.IsMultiple = Convert.ToBoolean(a["IsMultiple"]);
arrFilesList.MultipleEntity = (arrFilesList.IsMultiple == true ? Convert.ToString(a["MultipleEntity"]) : "");
arrFilesList.FileName = Convert.ToString(a["FileName"]);
string OldFilePath = string.Format("{0}{1}", Server.MapPath(arrFilesList.FilePath + "/"), arrFilesList.FileName);
string flag = Convert.ToString(a["Flag"]);
string fieldID = Convert.ToString(a["FieldID"]);
if (Request.Files["file"].ContentLength > 0 && !string.IsNullOrEmpty(arrFilesList.FilePath))
{
string extension = System.IO.Path.GetExtension(Request.Files["file"].FileName);
string path = string.Empty;
if (extension.ToUpper() == ".DOCX" || extension.ToUpper() == ".DOC")
{
try
{
//string FileName = System.IO.Path.GetFileNameWithoutExtension(Request.Files["file"].FileName) + DateTime.Now.Ticks + extension;
string FileName = System.IO.Path.GetFileNameWithoutExtension(arrFilesList.DisplayName) + "_" + DateTime.Now.ToString("dd_MMM_yyyy_hh_mm_ss") + extension;
path = string.Format("{0}{1}", Server.MapPath(arrFilesList.FilePath + "/"), FileName);
//File Name for Insert New record
arrFilesList.FileName = FileName;
Request.Files["file"].SaveAs(path);
TempData["FileName"] = FileName + "|" + Type;
TempData["Message"] = "FileUploaded" + "|" + Type + "|" + Category;
if (TemplateMapping.InsertTemplateFileDetails(arrFilesList, flag, fieldID, UserIDSession) == 1) //Success
{
if (System.IO.File.Exists(OldFilePath))
System.IO.File.Delete(OldFilePath);
}
else
{
TempData["AlertMessage"] = "error";
if (System.IO.File.Exists(path))
System.IO.File.Delete(path);
}
}
catch (Exception)
{
TempData["AlertMessage"] = "error";
if (System.IO.File.Exists(path))
System.IO.File.Delete(path);
}
}
else
TempData["Message"] = "FileNotValid|" + Type + "|" + Category;
}
else if (flag == "Edit")
{
TemplateMapping.InsertTemplateFileDetails(arrFilesList, flag, fieldID, UserIDSession);
TempData["Message"] = "FileUploaded|" + Type + "|" + Category;
}
else
TempData["Message"] = "FileNotValid|" + Type + "|" + Category;
return RedirectToAction("ManageTemplate");
}
catch (Exception ex)
{
TempData["AlertMessage"] = "error";
log.Error("Error: " + ex);
return RedirectToAction("ManageTemplate");
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
