public bool SaveReprintSource(lwg_ReprintSource i)
{
if (i != null)
{
if (i.ReprintSourceId > 0)
{
lwg_ReprintSource c = dbContext.lwg_ReprintSource.SingleOrDefault(it => it.ReprintSourceId == i.ReprintSourceId);
if (c != null)
{
c.Name = i.Name;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_ReprintSource.Count() > 0)
{
i.ReprintSourceId = dbContext.lwg_ReprintSource.OrderByDescending(pe => pe.ReprintSourceId).First().ReprintSourceId + 1;
}
else
{
i.ReprintSourceId = 1;
}
dbContext.lwg_ReprintSource.Add(i);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ReprintSourceBiz pBiz = new ReprintSourceBiz();
lwg_ReprintSource p;
if (string.IsNullOrEmpty(hdfID.Value))
{
p = new lwg_ReprintSource();
lblNote.Text = "Insert error, please try again";
}
else
{
p = pBiz.GetByID(int.Parse(hdfID.Value));
lblNote.Text = "Update error, please try again";
}
if (p != null)
{
p.Name = txtName.Text;
if (pBiz.SaveReprintSource(p))
{
BindingReprintSource();
txtName.Text = string.Empty;
pnEditReprintSource.Visible = false;
pnListReprintSource.Visible = true;
return;
}
}
lblNote.Visible = true;
}
protected void rptReprintSource_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ReprintSourceBiz pBiz = new ReprintSourceBiz();
lwg_ReprintSource p = pBiz.GetByID(int.Parse(e.CommandArgument.ToString()));
if (e.CommandName.Equals("EDIT"))
{
if (p != null)
{
btnAdd.Text = "Update";
txtTitle.Text = "Update Reprint Source";
hdfID.Value = e.CommandArgument.ToString();
pnEditReprintSource.Visible = true;
pnListReprintSource.Visible = false;
txtName.Text = p.Name;
}
}
else if (e.CommandName.Equals("DELETE"))
{
if (p != null)
{
if (pBiz.DeleteReprintSource(p))
{
BindingReprintSource();
}
}
}
}
public bool DeleteReprintSource(lwg_ReprintSource i)
{
if (i != null)
{
if (!dbContext.lwg_Catalog.Any(cl => cl.ReprintSourceId == i.ReprintSourceId))
{
dbContext.lwg_ReprintSource.Remove(i);
dbContext.SaveChanges();
return(true);
}
}
return(false);
}
public bool CheckAndInsertRepringSource(string reprinteSourceName, int catalogID)
{
lwg_ReprintSource lwg = dbContext.lwg_ReprintSource.SingleOrDefault(o => o.Name.ToLower().Equals(reprinteSourceName.ToLower()));
if (lwg == null)
{
lwg = new lwg_ReprintSource();
lwg.Name = reprinteSourceName;
SaveReprintSource(lwg);
}
if (!dbContext.lwg_ReprintSourceMapping.Any(o => o.CatalogID == catalogID && o.ReprintSourceID == lwg.ReprintSourceId))
{
lwg_ReprintSourceMapping reprintSourceMapping = new lwg_ReprintSourceMapping();
reprintSourceMapping.ReprintSourceID = lwg.ReprintSourceId;
reprintSourceMapping.CatalogID = catalogID;
dbContext.lwg_ReprintSourceMapping.Add(reprintSourceMapping);
dbContext.SaveChanges();
return(true);
}
return(false);
}