public bool SaveSeriesMapping(lwg_SeriesMapping lwg)
{
if (lwg != null && !dbContext.lwg_SeriesMapping.Any(o => o.SeriesID == lwg.SeriesID && o.CatalogID == lwg.CatalogID))
{
dbContext.lwg_SeriesMapping.Add(lwg);
dbContext.SaveChanges();
return(true);
}
return(false);
}
public bool DeleteSeriesMappingByID(int seriesID, int catalogID)
{
lwg_SeriesMapping lwg = dbContext.lwg_SeriesMapping.SingleOrDefault(o => o.SeriesID == seriesID && o.CatalogID == catalogID);
if (lwg != null)
{
dbContext.lwg_SeriesMapping.Remove(lwg);
dbContext.SaveChanges();
return(true);
}
return(false);
}
protected void btnSeries_Click(object sender, EventArgs e)
{
SeriesBiz sBiz = new SeriesBiz();
lwg_SeriesMapping lwg = new lwg_SeriesMapping();
lwg.CatalogID = ProductId;
lwg.SeriesID = int.Parse(drpSeries.SelectedValue);
if (sBiz.SaveSeriesMapping(lwg))
{
BindingSeries();
}
//TODO: save fail
}
protected void grdSeries_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.DataItem == null)
{
return;
}
lwg_SeriesMapping lg = (lwg_SeriesMapping)e.Row.DataItem;
if (lg != null)
{
Literal ltrProductDisplay = (Literal)e.Row.FindControl("ltrProductDisplay");
ltrProductDisplay.Text = lg.lwg_Catalog.TitleDisplay;
Literal ltrSeriesName = (Literal)e.Row.FindControl("ltrSeriesName");
ltrSeriesName.Text = lg.lwg_Series.Name;
LinkButton lnkbtnRemove = (LinkButton)e.Row.FindControl("lnkbtnRemove");
lnkbtnRemove.CommandArgument = lg.SeriesID.ToString();
}
}
public bool CheckAndInsertSeries(string seriesName, int catalogID)
{
lwg_Series lwg = dbContext.lwg_Series.SingleOrDefault(o => o.Name.ToLower().Equals(seriesName.ToLower()));
if (lwg == null)
{
lwg = new lwg_Series();
lwg.Name = seriesName;
SaveSeries(lwg);
}
if (!dbContext.lwg_SeriesMapping.Any(o => o.CatalogID == catalogID && o.SeriesID == lwg.SeriesId))
{
lwg_SeriesMapping seriesMapping = new lwg_SeriesMapping();
seriesMapping.CatalogID = catalogID;
seriesMapping.SeriesID = lwg.SeriesId;
dbContext.lwg_SeriesMapping.Add(seriesMapping);
dbContext.SaveChanges();
return(true);
}
return(false);
}
