public int AddSites(SitesManagementInfo SitesInfo) { int result = 0; DbCommand sqlStringCommand = this.database.GetSqlStringCommand(@"INSERT INTO [Ecshop_Sites] ([SitesName] ,[Code] ,[Province] ,[City] ,[IsDefault] ,[Sort] ,[Description]) VALUES (@SitesName ,@Code ,@Province ,@City ,@IsDefault ,@Sort ,@Description);SELECT @@IDENTITY"); this.database.AddInParameter(sqlStringCommand, "SitesName", DbType.String, SitesInfo.SitesName); this.database.AddInParameter(sqlStringCommand, "Code", DbType.String, SitesInfo.Code); this.database.AddInParameter(sqlStringCommand, "Province", DbType.String, SitesInfo.Province); this.database.AddInParameter(sqlStringCommand, "City", DbType.Int32, SitesInfo.City); this.database.AddInParameter(sqlStringCommand, "IsDefault", DbType.Int32, SitesInfo.IsDefault); this.database.AddInParameter(sqlStringCommand, "Sort", DbType.Int32, SitesInfo.Sort); this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, SitesInfo.Description); object obj = this.database.ExecuteScalar(sqlStringCommand); if (obj != null) { result = Convert.ToInt32(obj.ToString()); } return(result); }
public SitesManagementInfo GetSites(int SitesId) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_Sites WHERE SitesId = @SitesId"); this.database.AddInParameter(sqlStringCommand, "SitesId", DbType.Int32, SitesId); SitesManagementInfo result = null; using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { result = ReaderConvert.ReaderToModel <SitesManagementInfo>(dataReader); } return(result); }
public bool UpdateSites(SitesManagementInfo SitesInfo) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand(@"UPDATE [Ecshop_Sites] SET [SitesName] = @SitesName ,[Code] = @Code ,[Province] = @Province ,[City] = @City ,[IsDefault] =@IsDefault ,[Sort] = @Sort ,[Description] = @Description WHERE SitesId=@SitesId"); this.database.AddInParameter(sqlStringCommand, "SitesName", DbType.String, SitesInfo.SitesName); this.database.AddInParameter(sqlStringCommand, "Code", DbType.String, SitesInfo.Code); this.database.AddInParameter(sqlStringCommand, "Province", DbType.Int32, SitesInfo.Province); this.database.AddInParameter(sqlStringCommand, "City", DbType.Int32, SitesInfo.City); this.database.AddInParameter(sqlStringCommand, "IsDefault", DbType.String, SitesInfo.IsDefault); this.database.AddInParameter(sqlStringCommand, "Sort", DbType.String, SitesInfo.Sort); this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, SitesInfo.Description); this.database.AddInParameter(sqlStringCommand, "SitesId", DbType.Int32, SitesInfo.SitesId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }