public SavingResult SaveSettingL0(string SettingName, object SettingValue)
{
SavingResult res = new SavingResult();
//--
using (dbVisionEntities db = new dbVisionEntities())
{
tblSettingL0 SaveModel = SaveSettingL0(SettingName, SettingValue, db, res);
if (res.ExecutionResult == eExecutionResult.ValidationError)
{
return(res);
}
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.SettingL0ID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
public tblSettingL0 SaveSettingL0(string SettingName, object SettingValue, dbVisionEntities db, SavingResult res)
{
tblSettingL0 SaveModel = db.tblSettingL0.FirstOrDefault(r => r.SettingName == SettingName);
if (SaveModel == null) // New Entry
{
SaveModel = new tblSettingL0()
{
SettingName = SaveModel.SettingName,
};
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
db.tblSettingL0.Add(SaveModel);
}
else
{
SaveModel.redt = DateTime.Now;
db.tblSettingL0.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
}
switch ((eSettingValueType)SaveModel.SettingValueType)
{
case eSettingValueType.Varchar50:
SaveModel.SettingValueVC = (string)SettingValue;
break;
case eSettingValueType.Int:
SaveModel.SettingValueInt = (int?)SettingValue;
break;
case eSettingValueType.Long:
SaveModel.SettingValueLong = (long?)SettingValue;
break;
case eSettingValueType.DateTime:
SaveModel.SettingValueDateTime = (DateTime?)SettingValue;
break;
case eSettingValueType.Boolean:
SaveModel.SettingValueBoolean = (bool?)SettingValue;
break;
case eSettingValueType.Decimal:
SaveModel.SettingValueDecimal = (decimal?)SettingValue;
break;
}
return(SaveModel);
}
