public void save(SPR_ServerParameter pParam)
{
SPR_ServerParameter parameter = null;
using (var context = new SILOEntities())
{
List <SPR_ServerParameter> paramList = context.SPR_ServerParameter
.Where(param => param.SPR_Name == pParam.SPR_Name).ToList();
if (paramList.Count > 0)
{
parameter = paramList[0];
}
if (parameter == null)
{
parameter = new SPR_ServerParameter();
parameter.SPR_Id = pParam.SPR_Id;
parameter.SPR_Name = pParam.SPR_Name;
parameter.SPR_Value = pParam.SPR_Value;
context.Set <SPR_ServerParameter>().Add(parameter);
}
else
{
parameter.SPR_Value = pParam.SPR_Value;
}
context.SaveChanges();
}
}
public static void setServerParameterValue(string pParamName, string pParamValue)
{
ServerParameterRepository serverParamRepo = new ServerParameterRepository();
SPR_ServerParameter serverParam = new SPR_ServerParameter();
serverParam.SPR_Name = pParamName;
serverParam.SPR_Value = pParamValue;
serverParamRepo.save(serverParam);
}
public SPR_ServerParameter getByName(string pName)
{
SPR_ServerParameter paramValue = null;
try
{
using (var context = new SILOEntities())
{
List <SPR_ServerParameter> paramList = context.SPR_ServerParameter
.Where(param => param.SPR_Name == pName).ToList();
if (paramList.Count > 0)
{
paramValue = paramList[0];
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(paramValue);
}
public string getParamValue(string pName)
{
SPR_ServerParameter findedParam = this.getByName(pName);
return(findedParam == null ? "" : findedParam.SPR_Value.Trim());
}
