public tbl_Card_Types GetCardType(int CardTypeID)
{
try
{
tbl_Card_Types cardType = new DAL.tbl_Card_Types();
using (var db = new SoneriCISEntities())
{
cardType = db.tbl_Card_Types.Include("tbl_Card_Upgrade_Types").Include("tbl_Card_Upgrade_Types1").Include("tbl_Card_Charges").Where(a => a.ID == CardTypeID).FirstOrDefault();
}
return(cardType);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCardType(tbl_Card_Types row, List <tbl_Card_Types> UpgradeCardTypes)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Card_Types val = new DAL.tbl_Card_Types();
val = db.tbl_Card_Types.Where(a => a.ID == row.ID).FirstOrDefault();
if (db.tbl_Card_Types.Any(e => e.Title.ToLower() != val.Title.ToLower() && e.Title.ToLower() == row.Title.ToLower()))
{
throw new CustomException("Title already exists");
}
//if (db.tbl_Card_Types.Any(e => e.CardCode.ToLower() != val.CardCode.ToLower() && e.CardCode.ToLower() == row.CardCode.ToLower()))
// throw new CustomException("Code already exists");
val.Title = row.Title;
val.AuthorizationComments = row.AuthorizationComments;
val.AuthorizationStatus = row.AuthorizationStatus;
val.Description = row.Description;
val.IsActive = row.IsActive;
val.CardCode = row.CardCode;
val.IsIssuance = row.IsIssuance;
val.IsReplacement = row.IsReplacement;
val.IsUpgrade = row.IsUpgrade;
db.SaveChanges();
//update Upgrade Card Types
if (UpgradeCardTypes.Count > 0)
{
DeleteCardUpgradeType(row.ID);
AddCardUpgradeType(UpgradeCardTypes, row.ID);
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeleteCardType(int CardTypeID)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Card_Types val = new DAL.tbl_Card_Types();
val = db.tbl_Card_Types.Where(a => a.ID == CardTypeID).FirstOrDefault();
val.Title = val.Title;
val.AuthorizationComments = val.AuthorizationComments;
val.AuthorizationStatus = val.AuthorizationStatus;
val.Description = val.Description;
val.IsActive = false;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool CheckDuplicateCode(string CardCode)
{
try
{
tbl_Card_Types card = new DAL.tbl_Card_Types();
using (var db = new SoneriCISEntities())
{
card = db.tbl_Card_Types.Where(a => a.IsActive == true && a.CardCode == CardCode).FirstOrDefault();
}
if (card == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
