public bool SaveGenre(lwg_Genre p)
{
if (p != null)
{
if (p.GerneId > 0)
{
lwg_Genre c = dbContext.lwg_Genre.SingleOrDefault(ht => ht.GerneId == p.GerneId);
if (c != null)
{
c.Name = p.Name;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_Genre.Count() > 0)
{
p.GerneId = dbContext.lwg_Genre.OrderByDescending(pe => pe.GerneId).First().GerneId + 1;
}
else
{
p.GerneId = 1;
}
dbContext.lwg_Genre.Add(p);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
public bool SavePublisher(lwg_Publisher p)
{
if (p != null)
{
if (p.PublisherId > 0)
{
lwg_Publisher c = dbContext.lwg_Publisher.SingleOrDefault(ht => ht.PublisherId == p.PublisherId);
if (c != null)
{
c.Name = p.Name;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_Publisher.Count() > 0)
{
p.PublisherId = dbContext.lwg_Publisher.OrderByDescending(pe => pe.PublisherId).First().PublisherId + 1;
}
else
{
p.PublisherId = 1;
}
dbContext.lwg_Publisher.Add(p);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
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 DeleteEmail(int emailid)
{
if (emailid != 0)
{
var item = dbContent.Nop_EmailDirectory.Where(t => t.EmailID == emailid);
dbContent.Nop_EmailDirectory.Remove(item.First());
dbContent.SaveChanges();
return(true);
}
return(false);
}
public bool CheckAndInsertInstrTitle(string titleName, int catalogID, int titleTypeID)
{
try
{
lwg_InstrTitle lwg = context.lwg_InstrTitle.SingleOrDefault(o => o.Name.ToLower().Equals(titleName.ToLower()) && o.TitleTypeId == titleTypeID);
if (lwg == null)
{
lwg = new lwg_InstrTitle();
lwg.TitleTypeId = titleTypeID;
lwg.Name = titleName;
CatalogTitleTypeBiz cBiz = new CatalogTitleTypeBiz();
cBiz.SaveInstrTitle(lwg);
}
if (!context.lwg_CatalogTitle.Any(o => o.CatalogId == catalogID && o.InstrTitleId == lwg.Id))
{
lwg_CatalogTitle catalogTitle = new lwg_CatalogTitle();
catalogTitle.CatalogId = catalogID;
catalogTitle.InstrTitleId = lwg.Id;
context.lwg_CatalogTitle.Add(catalogTitle);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool InsertLicense(lwg_LicenseForm license)
{
if (license == null)
{
return(false);
}
try
{
license.CreatedDate = DateTime.Now;
context.lwg_LicenseForm.Add(license);
context.SaveChanges();
return(true);
}
catch
{
throw;
}
}
public bool SavePerson(lwg_Person h)
{
if (h != null)
{
if (h.PersonId > 0)
{
lwg_Person c = dbContext.lwg_Person.SingleOrDefault(ht => ht.PersonId == h.PersonId);
if (c != null)
{
c.Biography = h.Biography;
c.DOB = h.DOB;
c.DOD = h.DOD;
c.FirstLetter = h.FirstLetter;
c.FirstName = h.FirstName;
c.LastName = h.LastName;
c.NameDisplay = h.NameDisplay;
c.NameList = h.NameList;
c.NameSort = h.NameSort;
c.PictureID = h.PictureID;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_Person.Count() > 0)
{
h.PersonId = dbContext.lwg_Person.Max(ct => ct.PersonId) + 1;
}
else
{
h.PersonId = 1;
}
dbContext.lwg_Person.Add(h);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
public bool SaveSeries(lwg_Series p)
{
if (p != null)
{
if (p.SeriesId > 0)
{
lwg_Series c = dbContext.lwg_Series.SingleOrDefault(ht => ht.SeriesId == p.SeriesId);
if (c != null)
{
c.Name = p.Name;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_Series.Count() > 0)
{
p.SeriesId = dbContext.lwg_Series.OrderByDescending(pe => pe.SeriesId).First().SeriesId + 1;
}
else
{
p.SeriesId = 1;
}
dbContext.lwg_Series.Add(p);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
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);
}
// add audios into lwg_Audio
public void AddCatalogAudio(List <lwg_Audio> audioList)
{
dbContext.lwg_Audio.AddRange(audioList);
dbContext.SaveChanges();
}
public bool SaveCatalog(lwg_Catalog c)
{
try
{
if (c != null)
{
if (dbContext.lwg_Catalog.Any(ct => ct.CatalogId == c.CatalogId))
{
lwg_Catalog h = dbContext.lwg_Catalog.SingleOrDefault(ht => ht.CatalogId == c.CatalogId);
if (h != null)
{
//TODO: all file catalog
c.ArrangerGroupId = h.ArrangerGroupId; // allow null
c.Blurb = h.Blurb;
//p.CatalogId // increase by code
c.CatalogNumber = h.CatalogNumber;
c.Duration = h.Duration;
c.Format1 = h.Format1;
c.Format10 = h.Format10;
c.Format2 = h.Format2;
c.Format3 = h.Format3;
c.Format4 = h.Format4;
c.Format5 = h.Format5;
c.Format6 = h.Format6;
c.Format7 = h.Format7;
c.Format8 = h.Format8;
c.Format9 = h.Format9;
c.FSCprodcode = h.FSCprodcode;
c.Grade = h.Grade; // type : byte ?
c.InstrumentalId = h.InstrumentalId;
c.KaldbNumber = h.KaldbNumber;
c.pages = h.pages;
c.PDF = h.PDF;
c.PeriodId = h.PeriodId;
c.Price1 = h.Price1; // allow null
c.Price2 = h.Price2; // allow null
c.Price3 = h.Price3; // allow null
c.Price4 = h.Price4; // allow null
c.Price5 = h.Price5; // allow null
c.Price6 = h.Price6; // allow null
c.Price7 = h.Price7; // allow null
c.Price8 = h.Price8; // allow null
c.Price9 = h.Price9; // allow null
c.Price10 = h.Price10; // allow null
c.PTSprodcode = h.PTSprodcode;
c.QTFile1 = h.QTFile1;
c.QTFile2 = h.QTFile2;
c.QTFile3 = h.QTFile3;
c.QTFile4 = h.QTFile4;
c.QTFile5 = h.QTFile5;
c.QTFile6 = h.QTFile6;
c.QTFile7 = h.QTFile7;
c.QTFile8 = h.QTFile8;
c.QTFile9 = h.QTFile9;
c.QTFile10 = h.QTFile10;
c.QTFile11 = h.QTFile11;
c.recid = h.recid; // what's recid ?
c.ReprintSourceId = h.ReprintSourceId;
c.S4MasterSeries = h.S4MasterSeries;
c.S5MasterCategories = h.S5MasterCategories;
c.SeriesId = h.SeriesId;
c.SoundFile1 = h.SoundFile1;
c.SoundFile2 = h.SoundFile2;
c.SoundFile3 = h.SoundFile3;
c.SoundFile4 = h.SoundFile4;
c.SoundFile5 = h.SoundFile5;
c.SoundFile6 = h.SoundFile6;
c.SoundFile7 = h.SoundFile7;
c.SoundFile8 = h.SoundFile8;
c.SoundFile9 = h.SoundFile9;
c.SoundFile10 = h.SoundFile10;
c.SoundFile11 = h.SoundFile11;
c.SoundFile12 = h.SoundFile12;
c.SoundFile13 = h.SoundFile13;
c.SoundFile14 = h.SoundFile14;
c.SoundFile15 = h.SoundFile15;
c.SoundIcon = h.SoundIcon;
c.Subtitle = h.Subtitle;
c.TextLang = h.TextLang;
c.TitleDisplay = h.TitleDisplay;
c.TitleList = h.TitleList;
c.TitleSort = h.TitleSort;
c.Track01 = h.Track01;
c.Track02 = h.Track02;
c.Track03 = h.Track03;
c.Track04 = h.Track04;
c.Track05 = h.Track05;
c.Track06 = h.Track06;
c.Track07 = h.Track07;
c.Track08 = h.Track08;
c.Track09 = h.Track09;
c.Track10 = h.Track10;
c.Xform1 = h.Xform1;
c.Xform2 = h.Xform2;
c.Xform3 = h.Xform3;
c.Xform4 = h.Xform4;
c.Xform5 = h.Xform5;
c.InstrDetail = h.InstrDetail;
c.VocAccomp = h.VocAccomp;
c.Year = h.Year;
c.CopyrightYear = h.CopyrightYear;
c.TableofContents = h.TableofContents;
}
else
{
return(false);
}
}
else
{
dbContext.lwg_Catalog.Add(c);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
// add videos into lwg_Video
public void AddCatalogVideo(List <lwg_Video> videoList)
{
dbContext.lwg_Video.AddRange(videoList);
dbContext.SaveChanges();
}
