public void Save(BasicParameter objBasicParameter) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); if (objBasicParameter.PkId == 0) { sql = " insert into tbl_basic_parameter(ParamKey, ParamName, ParamValue) " + " values(@ParamKey, @ParamName, @ParamValue) "; parameterList.Add(new MySqlParameter("@ParamKey", objBasicParameter.ParamKey)); parameterList.Add(new MySqlParameter("@ParamName", objBasicParameter.ParamName)); parameterList.Add(new MySqlParameter("@ParamValue", objBasicParameter.ParamValue)); } else { sql = " update tbl_basic_parameter set ParamValue=@ParamValue where ParamKey=@ParamKey "; parameterList.Add(new MySqlParameter("@ParamKey", objBasicParameter.ParamKey)); parameterList.Add(new MySqlParameter("@ParamValue", objBasicParameter.ParamValue)); } DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray()); }
public bool CheckExists(BasicParameter objBasicParameter) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); sql = " select count(*) from tbl_basic_parameter where ParamKey=@ParamKey "; parameterList.Add(new MySqlParameter("@ParamKey", objBasicParameter.ParamKey)); return int.Parse(DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString()) > 0; }
public bool CheckExists_Parameter(BasicParameter objBasicParameter) { var repository = ServiceFactory.GetService<IBasicParameterRepository>(); return repository.CheckExists(objBasicParameter); }
public void Save_Parameter(BasicParameter objBasicParameter) { var repository = ServiceFactory.GetService<IBasicParameterRepository>(); repository.Save(objBasicParameter); }