public SysInfo AddSysInfo(SysInfo sysInfo)
{
SysInfoEntity entity = sysInfo.ToEntity();
this.dbContext.SysInfos.Add(entity);
this.dbContext.SaveChanges();
return(entity.ToModel());
}
public static SysInfo ToModel(this SysInfoEntity entity)
{
return(new SysInfo()
{
Id = entity.Id,
Name = entity.Name,
Description = entity.Description,
Detail = entity.Detail
});
}
public SysInfo AddSysInfo(SysInfo sysInfo)
{
if (sysInfo == null)
{
return(null);
}
DbParameter[] parameters = new DbParameter[]
{
new SqlParameter()
{
ParameterName = SpParamsOfSysInfo.Sp_Insert_SysInfo_Name,
Value = sysInfo.Name
},
new SqlParameter()
{
ParameterName = SpParamsOfSysInfo.Sp_Insert_SysInfo_Description,
Value = sysInfo.Description
},
new SqlParameter()
{
ParameterName = SpParamsOfSysInfo.Sp_Insert_SysInfo_Detail,
Value = sysInfo.Detail
}
};
using (DataSet dataSet = DbHelper.Instance.RunProcedureGetDataSet(SpNamesOfSysInfo.Sp_Insert_SysInfo, parameters))
{
SysInfoEntity entity = null;
if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows != null && dataSet.Tables[0].Rows.Count != 0)
{
DataRow dataRow = dataSet.Tables[0].Rows[0];
DataColumnCollection dataColumns = dataSet.Tables[0].Columns;
entity = new SysInfoEntity()
{
Id = (int)dataRow[dataColumns[0]],
Name = dataRow[dataColumns[1]].ToString(),
Description = dataRow[dataColumns[2]].ToString(),
Detail = dataRow[dataColumns[0]].ToString()
};
}
if (entity == null)
{
return(null);
}
return(entity.ToModel());
}
}
public SysInfo GetSysInfoByName(string name)
{
if (string.IsNullOrEmpty(name))
{
return(null);
}
DbParameter[] parameters = new DbParameter[]
{
new SqlParameter()
{
ParameterName = SpParamsOfSysInfo.Sp_Select_SysInfoByName_Name,
Value = name
}
};
using (DataSet dataSet = DbHelper.Instance.RunProcedureGetDataSet(SpNamesOfSysInfo.Sp_Select_SysInfoByName, parameters))
{
SysInfoEntity entity = null;
if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows != null && dataSet.Tables[0].Rows.Count != 0)
{
DataRow dataRow = dataSet.Tables[0].Rows[0];
DataColumnCollection dataColumns = dataSet.Tables[0].Columns;
entity = new SysInfoEntity()
{
Id = (int)dataRow[dataColumns[0]],
Name = dataRow[dataColumns[1]].ToString(),
Description = dataRow[dataColumns[2]].ToString(),
Detail = dataRow[dataColumns[3]].ToString()
};
}
if (entity == null)
{
return(null);
}
return(entity.ToModel());
}
}
public SysInfo GetSysInfoByName(string name)
{
SysInfoEntity entity = this.dbContext.SysInfos.FirstOrDefault(si => si.Name == name);
return(entity == null ? null : entity.ToModel());
}
public SysInfo GetSysInfoById(int id)
{
SysInfoEntity entity = this.dbContext.SysInfos.FirstOrDefault(si => si.Id == id);
return(entity == null ? null : entity.ToModel());
}
