//vsoalnki 13-11-2018
public BizResponseClass AddTemplateMaster(TemplateMasterReq Request, long userid)
{
try
{
TemplateMaster template = new TemplateMaster();
if (Request != null)
{
template.Status = Convert.ToInt16(ServiceStatus.Active);
template.UpdatedDate = UTC_To_IST();
template.CreatedDate = UTC_To_IST();
template.CreatedBy = userid;
template.TemplateID = Convert.ToInt64(Request.TemplateID);
template.TemplateName = Request.TemplateName;
template.AdditionalInfo = Request.AdditionalInfo;
template.CommServiceTypeID = Request.CommServiceTypeID;
template.Content = Request.Content;
_TemplateMaster.Add(template);
return(new BizResponseClass {
ReturnCode = enResponseCode.Success, ReturnMsg = EnResponseMessage.RecordAdded, ErrorCode = enErrorCode.Success
});
}
return(new BizResponseClass {
ReturnCode = enResponseCode.Fail, ReturnMsg = EnResponseMessage.InvalidInput, ErrorCode = enErrorCode.InvalidInput
});
}
catch (Exception ex)
{
HelperForLog.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.GetType().Name, ex);
throw ex;
}
}
//Previousely GetColumnsList()
public TemplateModel GetColumnsForTemplate(int templateId, int datasetId)
{
TemplateModel model = new TemplateModel();
try
{
List <TemplateColumnModel> columnList = new List <TemplateColumnModel>();
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
int accountId = 0;
if (datasetId != 0)
{
accountId = _dbContext.DatasetMaster.Where(d => d.DatasetId == datasetId)
.Join(_dbContext.InterfaceMaster, dm => dm.InterfaceId, im => im.InterfaceId, (dm, im) => im.CustomerId ?? im.PartyId).FirstOrDefault().Value;
}
TemplateMaster template = _dbContext.TemplateMaster.Where(t => t.TemplateId == templateId).FirstOrDefault();
columnList = _dbContext.TemplateDetails.Where(x => x.TemplateId == template.TemplateId).OrderBy(y => y.Order)
.Select(z => new TemplateColumnModel
{
Id = z.TemplateDetailId,
ColumnName = z.ColumnName,
IsMandatory = z.MandatoryFlag,
Order = z.Order,
IsTransformed = _dbContext.DatasetTransformation.Where(d => d.TargetColumn == z.ColumnName && d.DataDirection.ToUpper().Equals("OUTBOUND") &&
d.TemplateId == templateId && (d.AccountId == 0 || d.AccountId == accountId) && (d.DatasetId == 0 || d.DatasetId == datasetId)).Any()
}).ToList();
model.TemplateId = template.TemplateId;
model.TemplateName = template.TemplateName;
model.DataFeedId = template.DataFeedId;
model.Status = template.Status;
model.CreatedDate = template.CreatedDate;
model.CreatedBy = template.CreatedBy;
model.UpdatedBy = template.UpdatedBy;
model.UpdatedDate = template.UpdatedDate;
model.Columns = columnList;
}
}
catch
{
throw;
}
return(model);
}
public void AddTemplate(TemplateMaster template, List <TemplateDetails> templateColumns)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.TemplateMaster.Add(template);
_dbContext.SaveChanges();
int id = template.TemplateId;
templateColumns.ForEach(tc => tc.TemplateId = id);
_dbContext.TemplateDetails.AddRange(templateColumns);
_dbContext.SaveChanges();
}
}
catch
{
throw;
}
}
public TemplateMaster GetEmailTemplate(int TemplateCode)
{
TemplateMaster template = AccuitAdminDbContext.TemplateMasters.FirstOrDefault(k => k.TemplateCode == TemplateCode && k.TemplateType == (int)AspectEnums.TemplateType.Email && k.TemplateStatus == (int)AspectEnums.TemplateStatus.Active && k.IsDeleted == false);
return(template);
}
public IActionResult Create(TemplateFormMaster master)
{
TemplateMaster request = (TemplateMaster)master;
if (request != null && request.Formname != null && request.Jsonform != null && request.Iscurrent != null && request.Tempcatid != null)
{
var checkexisting = _dataContext.TemplateMaster.Where(x => x.Formname == request.Formname).FirstOrDefault();
if (checkexisting == null)
{
string createtable = CreateTable(request.Jsonform, request.Formname);
if (createtable == "Success")
{
_dataContext.TemplateMaster.Add(request);
_dataContext.SaveChanges();
TemplateCategoryB catb = (TemplateCategoryB)master;
TemplateCategoryC catc = (TemplateCategoryC)master;
if (catb != null && !String.IsNullOrEmpty(catb.categoryname))
{
catb.id = request.Masterid;
catb.templatecategoryid = request.Masterid;
_dataContext.TemplateCategoryB.Add(catb);
_dataContext.SaveChanges();
}
if (catc != null && !String.IsNullOrEmpty(catc.categoryname))
{
catc.id = request.Masterid;
catc.templatecategorybid = catb.id;
catc.templatecategoryid = request.Masterid;
_dataContext.TemplateCategoryC.Add(catc);
_dataContext.SaveChanges();
}
return(Ok("Success"));
//return CreatedAtAction(nameof(GetSingleForm), new { id = request.Masterid }, request);
}
else
{
return(BadRequest("Unable to create table"));
}
}
else
{
TemplateCategoryB catb = (TemplateCategoryB)master;
if (catb != null && !String.IsNullOrEmpty(catb.categoryname))
{
catb.templatecategoryid = checkexisting.Masterid;
var categorybExist = _dataContext.TemplateCategoryB.Where(x => x.categoryname == catb.categoryname && x.templatecategoryid == catb.templatecategoryid).FirstOrDefault();
if (categorybExist == null)
{
string oldform = request.Formname;
request.Formname = oldform + "_" + catb.categoryname;
string createtable = CreateTable(request.Jsonform, request.Formname);
if (createtable == "Success")
{
//_dataContext.TemplateMaster.Add(request);
//_dataContext.SaveChanges();
catb.id = checkexisting.Masterid;
catb.templatecategoryid = checkexisting.Masterid;
_dataContext.TemplateCategoryB.Add(catb);
_dataContext.SaveChanges();
}
return(Ok("Success"));
}
TemplateCategoryC catc = (TemplateCategoryC)master;
if (catc != null && !String.IsNullOrEmpty(catc.categoryname))
{
catc.templatecategoryid = checkexisting.Masterid;
catc.templatecategorybid = categorybExist.templatecategoryid;
var categorycExist = _dataContext.TemplateCategoryC.Where(x => x.categoryname == catc.categoryname && x.templatecategoryid == catc.templatecategoryid).FirstOrDefault();
if (categorycExist == null)
{
string oldform = request.Formname;
request.Formname = oldform + "_" + catc.categoryname;
string createtable = CreateTable(request.Jsonform, request.Formname);
if (createtable == "Success")
{
//_dataContext.TemplateMaster.Add(request);
//_dataContext.SaveChanges();
catc.id = request.Masterid;
catc.templatecategoryid = request.Masterid;
_dataContext.TemplateCategoryC.Add(catc);
_dataContext.SaveChanges();
}
return(Ok("Success"));
}
}
return(Ok("Form Exists before"));
}
return(Ok("Form Exists"));
}
}
else
{
return(BadRequest("Invalid/Bad Request"));
}
//if (request != null && request.Formname != null && request.Jsonform != null && request.Iscurrent != null && request.Tempcatid != null)
//{
// var checkexisting = _dataContext.TemplateMaster.Where(x => x.Formname == request.Formname).FirstOrDefault();
// if (checkexisting == null)
// {
// string createtable = CreateTable(request.Jsonform, request.Formname);
// if (createtable == "Success")
// {
// _dataContext.TemplateMaster.Add(request);
// _dataContext.SaveChanges();
// return Ok("Success");
// //return CreatedAtAction(nameof(GetSingleForm), new { id = request.Masterid }, request);
// }
// else
// {
// return BadRequest("Unable to create table");
// }
// }
// else
// {
// return BadRequest("Form Exists");
// }
//}
//else
//{
// return BadRequest("Invalid/Bad Request");
//}
}
public void UpdateTemplate(TemplateMaster template) //List<TemplateDetails> templateColumns
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
var entity = _dbContext.TemplateMaster.Where(t => t.TemplateId == template.TemplateId).FirstOrDefault();
entity.TemplateName = template.TemplateName;
entity.Status = template.Status;
entity.UpdatedBy = template.UpdatedBy;
entity.UpdatedDate = template.UpdatedDate;
_dbContext.TemplateMaster.Update(entity);
#region
//code_for_update template columns
////get all existing records
//List<TemplateDetails> existingRecords = (from existCols in _dbContext.TemplateDetails
// where (existCols.TemplateId == template.TemplateId)
// select existCols).ToList();
////delete removed records
//List<TemplateDetails> deleteRecords = existingRecords.Where(ex => {
// var found = templateColumns.Where(t => t.TemplateDetailId == ex.TemplateDetailId).FirstOrDefault();
// if (found != null) return false; else return true;
//}).ToList();
////delete records from outgestion maping also
//OutgestionDataAccess outgestion = new OutgestionDataAccess(_connectionString);
//if (deleteRecords.Count > 0)
//{
// outgestion.DeleteMapRecordForTemplateId(_dbContext, deleteRecords);
// _dbContext.SaveChanges();
//}
////Delete record(s) for given template Id
//_dbContext.RemoveRange(deleteRecords);
////Modify/Add records
//templateColumns.ForEach(x => {
// var existingRecord = existingRecords.Where(y => y.TemplateDetailId == x.TemplateDetailId).FirstOrDefault();
// //look for modified column name in mapping and replace with new column data
// if (existingRecord != null) {
// var templateDetailsEntity = _dbContext.TemplateDetails.Where(t=>t.TemplateDetailId== x.TemplateDetailId).FirstOrDefault();
// if( existingRecord.ColumnName != x.ColumnName || existingRecord.MandatoryFlag != x.MandatoryFlag)
// {
// templateDetailsEntity.ColumnName = x.ColumnName;
// templateDetailsEntity.MandatoryFlag = x.MandatoryFlag;
// templateDetailsEntity.UpdatedBy = x.UpdatedBy;
// templateDetailsEntity.UpdatedDate = x.UpdatedDate;
// }
// templateDetailsEntity.Order = x.Order;
// _dbContext.TemplateDetails.Update(templateDetailsEntity);
// }
// else //Add record if not exists
// {
// TemplateDetails tempNewRecord = Extensions.Clone(x);
// tempNewRecord.TemplateDetailId = 0;
// tempNewRecord.CreatedDate = DateTime.Now;
// tempNewRecord.CreatedBy = x.UpdatedBy;
// tempNewRecord.UpdatedBy = null;
// tempNewRecord.UpdatedDate = null;
// _dbContext.Add(tempNewRecord);
// }
//});
////check for status and update mapping status accordingly
//outgestion.OutgestionStatusUpdateForTemplateId(_dbContext, template.TemplateId, template.Status);
#endregion
_dbContext.SaveChanges();
}
}
catch
{
throw;
}
}
