/// <summary>
/// Get Custom Template by CustomColumnId
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public CustomTemplateDataModel GetCustomTemplateById(int id)
{
var customTemplate = new CustomTemplateDataModel();
try
{
var query = dbContext.CustomTemplate.AsQueryable();
customTemplate = query.Where(x => x.CustomColumnId == id && x.Status != CommonService.EnumStatus.Deleted.ToString()).FirstOrDefault();
}
catch (Exception exception)
{
commonService.LogException(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, exception);
}
return(customTemplate);
}
/// <summary>
/// Update Custom Template
/// </summary>
/// <param name="newCustomTemplate"></param>
/// <returns></returns>
public CustomTemplateDataModel UpdateCustomTemplate(CustomTemplateDataModel newCustomTemplate)
{
try
{
if (newCustomTemplate == null)
{
throw new ArgumentNullException("CustomTemplate");
}
this.dbContext.SaveChanges();
}
catch (Exception exception)
{
commonService.LogException(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, exception);
}
return(newCustomTemplate);
}
public ActionResult AddCustomTemplate(string customColumnId, string notes, string columnText)
{
CustomTemplateModel customTemplate = new CustomTemplateModel();
if (Request.UrlReferrer != null)
{
customTemplate.PreviousPageUrl = Request.UrlReferrer.AbsoluteUri;
}
string result = string.Empty;
var currentUser = commonService.GetCurrentUser();
if (currentUser == null)
{
result = "Login";
return(Json(result));
}
string fileName = string.Empty;
string directoryPath = "";
try
{
if (!string.IsNullOrEmpty(customColumnId))
{
var customTemplateExist = customTemplateService.GetCustomTemplateById(Convert.ToInt32(customColumnId));
if (customTemplateExist == null)
{
CustomTemplateDataModel model = new CustomTemplateDataModel();
if (model != null)
{
#region Attachment Uploads
IList <HttpPostedFileBase> files = new List <HttpPostedFileBase>();
if (Request.Files != null)
{
if (Request.Files.Count > 0)
{
var requestFile = Request.Files[0];
files.Add(requestFile);
fileName = Path.GetFileName(requestFile.FileName);
if (!string.IsNullOrEmpty(fileName))
{
directoryPath = Server.MapPath(customTemplatePath + customColumnId + "//");
if (!Directory.Exists(directoryPath))
{
Directory.CreateDirectory(directoryPath);
}
var path = Path.Combine(directoryPath, fileName);
requestFile.SaveAs(path);
model.FileLocation = Path.Combine(customColumnId + "//" + fileName);
}
}
}
#endregion
model.CustomColumnId = Convert.ToInt32(customColumnId);
model.CreatedAt = DateTime.Now;
model.CreatedBy = currentUser.UserId;
model.UpdatedAt = DateTime.Now;
model.Status = CommonService.EnumStatus.Active.ToString();
model.ColumnText = columnText;
model.Notes = notes;
customTemplateService.AddcustomTemplate(model);
result = "True";
}
}
else
{
result = "Existing";
}
}
}
catch (Exception exception)
{
commonService.LogException(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, exception);
}
return(Json(result));
}
