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