public int AddAttributeVal(IList <tbl_AttributeValues> tblAttributeValues)
{
try
{
IGenericDataRepository <tbl_AttributeValues> repository = new GenericDataRepository <tbl_AttributeValues>();
//tbl_AttributeValues DuplicateCheck = FindAttributeValue(tblAttributeValues.FirstOrDefault().AttributeValue);
//if (DuplicateCheck == null)
//{
foreach (var item in tblAttributeValues)
{
item.AttributeValue = item.AttributeValue.Trim();
repository.Add(item);
}
return(1);
}
catch (Exception)
{
throw;
}
//}
//else
//{
// return 0;
//}
}
public void AddErrorLog(tbl_ErrorLog tblErrorLog)
{
try
{
IGenericDataRepository <tbl_ErrorLog> repository = new GenericDataRepository <tbl_ErrorLog>();
repository.Add(tblErrorLog);
}
catch (Exception ex)
{
throw;
}
}
public void AddBuzRules(tbl_BusinessRule tblbuzrules)
{
try
{
IGenericDataRepository <tbl_BusinessRule> repository = new GenericDataRepository <tbl_BusinessRule>();
repository.Add(tblbuzrules);
}
catch (Exception)
{
throw;
}
}
public void AddBuzRulesAttrMapping(tbl_BuzRulesAttrMapping tblbuzruleattrmapping)
{
try
{
IGenericDataRepository <tbl_BuzRulesAttrMapping> repository = new GenericDataRepository <tbl_BuzRulesAttrMapping>();
repository.Add(tblbuzruleattrmapping);
}
catch (Exception)
{
throw;
}
}
public void AddProduct(tbl_Products tblProducts)
{
try
{
IGenericDataRepository <tbl_Products> repository = new GenericDataRepository <tbl_Products>();
repository.Add(tblProducts);
}
catch (Exception)
{
throw;
}
}
public void AddDestination(tbl_Destination tblDestination)
{
try
{
IGenericDataRepository <tbl_Destination> repository = new GenericDataRepository <tbl_Destination>();
repository.Add(tblDestination);
}
catch (Exception)
{
throw;
}
}
public void AddInterface(tbl_Interface tblInterface)
{
try
{
IGenericDataRepository <tbl_Interface> repository = new GenericDataRepository <tbl_Interface>();
repository.Add(tblInterface);
}
catch (Exception)
{
throw;
}
}
public void AddAppVersion(tbl_AppVersion tblAppVersion)
{
try
{
IGenericDataRepository <tbl_AppVersion> repository = new GenericDataRepository <tbl_AppVersion>();
repository.Add(tblAppVersion);
}
catch (Exception)
{
throw;
}
}
public void AddDistributionType(tbl_DistributionType tblDistributionType)
{
try
{
IGenericDataRepository <tbl_DistributionType> repository = new GenericDataRepository <tbl_DistributionType>();
repository.Add(tblDistributionType);
}
catch (Exception)
{
throw;
}
}
public void AddRoles(tbl_Roles tblRoles)
{
try
{
IGenericDataRepository <tbl_Roles> repository = new GenericDataRepository <tbl_Roles>();
repository.Add(tblRoles);
}
catch (Exception)
{
throw;
}
}
public void AddPeriodType(tbl_PeriodType tblPeriodType)
{
try
{
IGenericDataRepository <tbl_PeriodType> repository = new GenericDataRepository <tbl_PeriodType>();
repository.Add(tblPeriodType);
}
catch (Exception)
{
throw;
}
}
public void AddLifeCycle(tbl_LifeCycle tblLifeCycles)
{
try
{
IGenericDataRepository <tbl_LifeCycle> repository = new GenericDataRepository <tbl_LifeCycle>();
repository.Add(tblLifeCycles);
}
catch (Exception)
{
throw;
}
}
public void AddApplication(tbl_Applications tblApplications)
{
try
{
IGenericDataRepository <tbl_Applications> repository = new GenericDataRepository <tbl_Applications>();
repository.Add(tblApplications);
}
catch (Exception)
{
throw;
}
}
public void AddChannelAlert(tbl_ChannelAlert tblchannelalerts)
{
try
{
IGenericDataRepository <tbl_ChannelAlert> repository = new GenericDataRepository <tbl_ChannelAlert>();
repository.Add(tblchannelalerts);
}
catch (Exception)
{
throw;
}
}
public void AddBuzProd(tbl_BuzProd tblbuzprod)
{
try
{
IGenericDataRepository <tbl_BuzProd> repository = new GenericDataRepository <tbl_BuzProd>();
repository.Add(tblbuzprod);
}
catch (Exception)
{
throw;
}
}
public void AddChannelAlertsAttrMapping(tbl_ChannelAlertAttrMapping tblchannelalertattrmapping)
{
try
{
IGenericDataRepository <tbl_ChannelAlertAttrMapping> repository = new GenericDataRepository <tbl_ChannelAlertAttrMapping>();
repository.Add(tblchannelalertattrmapping);
}
catch (Exception)
{
throw;
}
}
public void AddLOB(tbl_LOB tblLOB)
{
try
{
IGenericDataRepository <tbl_LOB> repository = new GenericDataRepository <tbl_LOB>();
repository.Add(tblLOB);
}
catch (Exception)
{
throw;
}
}
public void AddUserData(tbl_UserData tblUserData)
{
try
{
IGenericDataRepository <tbl_UserData> repository = new GenericDataRepository <tbl_UserData>();
repository.Add(tblUserData);
}
catch (Exception)
{
throw;
}
}
public void AddFrequencyType(tbl_FrequencyType tblFrequencyType)
{
try
{
IGenericDataRepository <tbl_FrequencyType> repository = new GenericDataRepository <tbl_FrequencyType>();
repository.Add(tblFrequencyType);
}
catch (Exception)
{
throw;
}
}
public void AddDA(tbl_DesignAccelerator tblDesignAccelerator)
{
try
{
IGenericDataRepository <tbl_DesignAccelerator> repository = new GenericDataRepository <tbl_DesignAccelerator>();
repository.Add(tblDesignAccelerator);
}
catch (Exception)
{
throw;
}
}
public void AddInterfaceAttrMapping(tbl_InterfaceAttrMapping tblInterfaceAttrMapping)
{
try
{
IGenericDataRepository <tbl_InterfaceAttrMapping> repository = new GenericDataRepository <tbl_InterfaceAttrMapping>();
repository.Add(tblInterfaceAttrMapping);
}
catch (Exception)
{
throw;
}
}
public void AddAttribute(tbl_Attribute tblAttribute)
{
try
{
IGenericDataRepository <tbl_Attribute> repository = new GenericDataRepository <tbl_Attribute>();
repository.Add(tblAttribute);
}
catch (Exception)
{
throw;
}
}
public void AddModule(tbl_Module tblModule)
{
try
{
IGenericDataRepository <tbl_Module> repository = new GenericDataRepository <tbl_Module>();
repository.Add(tblModule);
}
catch (Exception)
{
throw;
}
}
public void AddClient(tbl_Clients tblClient)
{
try
{
IGenericDataRepository <tbl_Clients> repository = new GenericDataRepository <tbl_Clients>();
repository.Add(tblClient);
}
catch (Exception)
{
throw;
}
}
public int SaveData(IList <tbl_RoleScreenMapping> screenRoleMapping)
{
try
{
IGenericDataRepository <tbl_RoleScreenMapping> repository = new GenericDataRepository <tbl_RoleScreenMapping>();
foreach (var item in screenRoleMapping)
{
repository.Add(item);
}
return(1);
}
catch (Exception)
{
return(0);
}
}
public int SaveBuzRulesDataMapping(IList <tbl_BuzRulesAttrMapping> tblBusinessRulesAttrMapping)
{
try
{
IGenericDataRepository <tbl_BuzRulesAttrMapping> repository = new GenericDataRepository <tbl_BuzRulesAttrMapping>();
foreach (var item in tblBusinessRulesAttrMapping)
{
repository.Add(item);
}
return(1);
}
catch (Exception)
{
return(0);
}
}
public int SaveReports(IList <tbl_Reports> tblReports)
{
try
{
IGenericDataRepository <tbl_Reports> repository = new GenericDataRepository <tbl_Reports>();
foreach (var item in tblReports)
{
repository.Add(item);
}
return(1);
}
catch (Exception)
{
return(0);
}
}
//Save changes
public int SaveDataMapping(IList <tbl_InterfaceAttrMapping> tblInterfaceAttributeMapping)
{
try
{
IGenericDataRepository <tbl_InterfaceAttrMapping> repository = new GenericDataRepository <tbl_InterfaceAttrMapping>();
foreach (var item in tblInterfaceAttributeMapping)
{
repository.Add(item);
}
return(1);
}
catch (Exception)
{
return(0);
}
}
public ActionResult AddQuestion(AddQuestionsToExamViewModel vm, String ExamId)
{
if (String.IsNullOrEmpty(ExamId))
{
ViewBag.Error = "Exam parameter missing."; return(View("Error"));
}
var exam = new GenericDataRepository <Exam>().GetSingle(e => e.Id == vm.ExamId);
Question question = new Question()
{
QuestionText = vm.QuestionText, Id = Guid.NewGuid().ToString(), Exam = exam
};
var QuestionRepository = new GenericDataRepository <Question>();
QuestionRepository.Add(question);
return(RedirectToAction(actionName: nameof(ListQuestions), routeValues: new { @ExamId = vm.ExamId }));
}
public int SaveChannelAlertDataMapping(IList <tbl_ChannelAlertAttrMapping> tblChannelAlertAttrMapping)
{
try
{
IGenericDataRepository <tbl_ChannelAlertAttrMapping> repository = new GenericDataRepository <tbl_ChannelAlertAttrMapping>();
//if(tblChannelAlertAttrMapping.Count > 0)
//{
foreach (var item in tblChannelAlertAttrMapping)
{
repository.Add(item);
}
return(1);
//}
//else
//{
// return 0;
//}
}
catch (Exception)
{
return(0);
}
}