public void UpdateColumnNames(FormSettingBO FormSettingBO, string FormId)
{
Guid Id = new Guid(FormId);
try
{
using (var context = DataObjectFactory.CreateContext())
{
IQueryable <ResponseDisplaySetting> ColumnList = context.ResponseDisplaySettings.Where(x => x.FormId == Id);
//Delete old columns
foreach (var item in ColumnList)
{
context.ResponseDisplaySettings.DeleteObject(item);
}
context.SaveChanges();
//insert new columns
ResponseDisplaySetting ResponseDisplaySettingEntity = new ResponseDisplaySetting();
foreach (var item in FormSettingBO.ColumnNameList)
{
ResponseDisplaySettingEntity = Mapper.ToColumnName(item, Id);
context.AddToResponseDisplaySettings(ResponseDisplaySettingEntity);
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw (ex);
}
}
internal static ResponseDisplaySetting Map(string FormId, int i, string Column)
{
ResponseDisplaySetting ResponseDisplaySetting = new ResponseDisplaySetting();
ResponseDisplaySetting.FormId = new Guid(FormId);
ResponseDisplaySetting.ColumnName = Column;
ResponseDisplaySetting.SortOrder = i;
return(ResponseDisplaySetting);
}
public void InsertFormDefaultSettings(string formId, bool isSqlProject, List <string> controlsNameList)
{
#if false
try
{
//Delete old columns
using (var Context = DataObjectFactory.CreateContext())
{
Guid Id = new Guid(formId);
IQueryable <ResponseDisplaySetting> ColumnList = Context.ResponseDisplaySettings.Where(x => x.FormId == Id);
foreach (var item in ColumnList)
{
Context.ResponseDisplaySettings.DeleteObject(item);
}
Context.SaveChanges();
}
// Adding new columns
List <string> ColumnNames = new List <string>();
if (!isSqlProject)
{
ColumnNames = MetaDaTaColumnNames();
}
else
{
ColumnNames = controlsNameList;
}
int i = 1;
foreach (string Column in ColumnNames)
{
using (var Context = DataObjectFactory.CreateContext())
{
ResponseDisplaySetting SettingEntity = Mapper.Map(formId, i, Column);
Context.AddToResponseDisplaySettings(SettingEntity);
Context.SaveChanges();
}
i++;
}
}
catch (Exception ex)
{
throw (ex);
}
#endif
}
