protected void btnAdd_Click(object sender, EventArgs e)
{
InstrumentalBiz pBiz = new InstrumentalBiz();
lwg_Instrumental p;
if (string.IsNullOrEmpty(hdfID.Value))
{
p = new lwg_Instrumental();
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.ShortName = txtShortName.Text;
p.LongName = txtLongName.Text;
if (pBiz.SaveInstrumental(p))
{
rptInstrumental.DataSource = pBiz.GetListInstrumental();
rptInstrumental.DataBind();
txtLongName.Text = string.Empty;
txtShortName.Text = string.Empty;
pnEditInstrumental.Visible = false;
pnListInstrumental.Visible = true;
return;
}
}
lblNote.Visible = true;
}
protected void rptInstrumental_ItemCommand(object source, RepeaterCommandEventArgs e)
{
InstrumentalBiz pBiz = new InstrumentalBiz();
lwg_Instrumental p = pBiz.GetByID(int.Parse(e.CommandArgument.ToString()));
if (e.CommandName.Equals("EDIT"))
{
if (p != null)
{
btnAdd.Text = "Update";
txtTitle.Text = "Update Instrumental";
hdfID.Value = e.CommandArgument.ToString();
pnEditInstrumental.Visible = true;
pnListInstrumental.Visible = false;
txtShortName.Text = p.ShortName;
txtLongName.Text = p.LongName;
}
}
else if (e.CommandName.Equals("DELETE"))
{
if (p != null)
{
if (pBiz.DeleteInstrumental(p))
{
BindingInstrumental();
}
}
}
}
public bool SaveInstrumental(lwg_Instrumental i)
{
if (i != null)
{
if (i.InstrumentalId > 0)
{
lwg_Instrumental c = dbContext.lwg_Instrumental.SingleOrDefault(it => it.InstrumentalId == i.InstrumentalId);
if (c != null)
{
c.LongName = i.LongName;
c.ShortName = i.ShortName;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_Instrumental.Count() > 0)
{
i.InstrumentalId = dbContext.lwg_Instrumental.OrderByDescending(pe => pe.InstrumentalId).First().InstrumentalId + 1;
}
else
{
i.InstrumentalId = 1;
}
dbContext.lwg_Instrumental.Add(i);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
public bool DeleteInstrumental(lwg_Instrumental i)
{
if (i != null)
{
if (!dbContext.lwg_Catalog.Any(cl => cl.InstrumentalId == i.InstrumentalId))
{
dbContext.lwg_Instrumental.Remove(i);
dbContext.SaveChanges();
return(true);
}
}
return(false);
}
public int CheckAndInsertInstrumental(string instrumentalName)
{
try
{
lwg_Instrumental lwg = dbContext.lwg_Instrumental.SingleOrDefault(o => o.ShortName.ToLower().Equals(instrumentalName.ToLower()));
if (lwg == null)
{
lwg = new lwg_Instrumental();
lwg.ShortName = instrumentalName;
lwg.LongName = instrumentalName;
SaveInstrumental(lwg);
}
return(lwg.InstrumentalId);
}
catch (Exception ex)
{
return(0);
}
}
