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