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