public tblSettingsL1 SaveSettingL1(string SettingName, object SettingValue, int CompanyID, dbVisionEntities db, SavingResult res)
{
tblSettingMasterL1 SaveModelMaster = db.tblSettingMasterL1.FirstOrDefault(r => r.SettingName == SettingName);
if (SaveModelMaster == null)
{
res.ValidationError = "Setting not found.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(null);
}
tblSettingsL1 SaveModel = db.tblSettingsL1.FirstOrDefault(r => r.SettingName == SettingName && r.CompanyID == CompanyID);
if (SaveModel == null) // New Entry
{
SaveModel = new tblSettingsL1()
{
SettingName = SaveModelMaster.SettingName,
CompanyID = CompanyID
};
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
db.tblSettingsL1.Add(SaveModel);
}
else
{
SaveModel.redt = DateTime.Now;
db.tblSettingsL1.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
}
switch ((eSettingValueType)SaveModelMaster.SettingValueType)
{
case eSettingValueType.Varchar50:
SaveModel.SettingValueVC = (string)SettingValue;
break;
case eSettingValueType.Int:
/// specially for enum type, casted to int then nullable int
SaveModel.SettingValueInt = (SettingValue != null ? (int?)((int)SettingValue) : null);
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);
}
public object GetSettingL1(string SettingName, long ComapnyID)
{
using (dbVisionEntities db = new dbVisionEntities())
{
tblSettingMasterL1 SaveModelMaster = db.tblSettingMasterL1.FirstOrDefault(r => r.SettingName == SettingName);
if (SaveModelMaster == null)
{
throw new Exception($"Setting name not found. Setting Name : {SettingName}");
}
tblSettingsL1 SaveModel = db.tblSettingsL1.FirstOrDefault(r => r.SettingName == SettingName && r.CompanyID == ComapnyID);
//object SettingValue = null;
if (SaveModel == null)
{
if (SaveModelMaster != null)
{
switch ((eSettingValueType)SaveModelMaster.SettingValueType)
{
case eSettingValueType.Varchar50:
return(SaveModelMaster.SettingValueVC);
case eSettingValueType.Int:
return(SaveModelMaster.SettingValueInt);
case eSettingValueType.Long:
return(SaveModelMaster.SettingValueLong);
case eSettingValueType.DateTime:
return(SaveModelMaster.SettingValueDateTime);
case eSettingValueType.Boolean:
return(SaveModelMaster.SettingValueBoolean);
case eSettingValueType.Decimal:
return(SaveModelMaster.SettingValueDecimal);
}
}
}
else
{
switch ((eSettingValueType)SaveModelMaster.SettingValueType)
{
case eSettingValueType.Varchar50:
return(SaveModel.SettingValueVC);
case eSettingValueType.Int:
return(SaveModel.SettingValueInt);
case eSettingValueType.Long:
return(SaveModel.SettingValueLong);
case eSettingValueType.DateTime:
return(SaveModel.SettingValueDateTime);
case eSettingValueType.Boolean:
return(SaveModel.SettingValueBoolean);
case eSettingValueType.Decimal:
return(SaveModel.SettingValueDecimal);
}
}
}
return(null);
}
