public string GetCarSeriesName(int id) { CarSeriesInfo entity = GetCarSeriesModel(id, true); if (entity == null) { return(string.Empty); } return(entity.Name); }
public CarSeriesInfo GetCarSeriesModel(int id, bool fromCache = false) { CarSeriesInfo entity = null; List <CarSeriesInfo> list = GetCarSeriesList(fromCache); entity = list.Find(c => c.ID == id); return(entity); }
private void LoadData() { int id = GetInt("id"); if (id > 0) { CurrentCarSeries = Cars.Instance.GetCarSeriesModel(id, true); txtName.Value = CurrentCarSeries.Name; SetSelectedByValue(ddlCarBrand, CurrentCarSeries.BrandID.ToString()); } }
protected void btnSubmit_Click(object sender, EventArgs e) { CarSeriesInfo entity = new CarSeriesInfo(); int id = GetInt("id"); if (id > 0) entity = Cars.Instance.GetCarSeriesModel(id, true); FillData(entity); if (id > 0) Cars.Instance.UpdateCarSeries(entity); else Cars.Instance.AddCarSeries(entity); Cars.Instance.ReloadCarSeriesListCache(); Response.Redirect("carseriesmg.aspx"); }
public static CarSeriesInfo PopulateCarSeriesInfo(IDataReader reader) { CarSeriesInfo entity = new CarSeriesInfo() { ID = (int)reader["ID"], Name = reader["Name"] as string, BrandID = (int)reader["BrandID"], BrandName = reader["BrandName"] as string, BrandNameIndex = reader["BrandNameIndex"] as string }; return(entity); }
public static CarSeriesInfo PopulateCarSeriesInfo(IDataReader reader) { CarSeriesInfo entity = new CarSeriesInfo() { ID = (int)reader["ID"], Name = reader["Name"] as string, BrandID = (int)reader["BrandID"], BrandName = reader["BrandName"] as string, BrandNameIndex = reader["BrandNameIndex"] as string }; return entity; }
private void FillData(CarSeriesInfo entity) { entity.Name = txtName.Value; entity.BrandID = DataConvert.SafeInt(ddlCarBrand.SelectedValue); }
public abstract void UpdateCarSeries(CarSeriesInfo entity);
public override void UpdateCarSeries(CarSeriesInfo entity) { string sql = @" UPDATE ComOpp_CarSeries set Name = @Name ,BrandID = @BrandID WHERE ID=@ID"; SqlParameter[] parameters = { new SqlParameter("@ID", entity.ID), new SqlParameter("@Name", entity.Name), new SqlParameter("@BrandID", entity.BrandID) }; SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, parameters); }
public abstract int AddCarSeries(CarSeriesInfo entity);
public int AddCarSeries(CarSeriesInfo entity) { return(CommonDataProvider.Instance().AddCarSeries(entity)); }
public override int AddCarSeries(CarSeriesInfo entity) { string sql = @"INSERT INTO ComOpp_CarSeries( [Name] ,[BrandID] )VALUES( @Name ,@BrandID );SELECT @@IDENTITY"; SqlParameter[] p = { new SqlParameter("@Name",entity.Name), new SqlParameter("@BrandID",entity.BrandID) }; return DataConvert.SafeInt(SqlHelper.ExecuteScalar(_con, CommandType.Text, sql, p)); }
public abstract void UpdateCarSeries(CarSeriesInfo entity);
public abstract int AddCarSeries(CarSeriesInfo entity);
public int AddCarSeries(CarSeriesInfo entity) { return CommonDataProvider.Instance().AddCarSeries(entity); }
public void UpdateCarSeries(CarSeriesInfo entity) { CommonDataProvider.Instance().UpdateCarSeries(entity); }
public void UpdateCarSeries(CarSeriesInfo entity) { CommonDataProvider.Instance().UpdateCarSeries(entity); }