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()); }