public bool UpdateCardCharges(tbl_Card_Charges row)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Card_Charges val = new DAL.tbl_Card_Charges();
val = db.tbl_Card_Charges.Where(a => a.ID == row.ID).FirstOrDefault();
if (db.tbl_Card_Charges.Any(e => e.Title.ToLower() != val.Title.ToLower() && e.Title.ToLower() == row.Title.ToLower()))
{
throw new CustomException("Title already exists!");
}
val.Title = row.Title;
val.Amount = row.Amount;
val.AuthorizationComments = row.AuthorizationComments;
val.AuthorizationStatus = row.AuthorizationStatus;
val.CardTypeID = row.CardTypeID;
val.IsActive = row.IsActive;
val.IsFED = row.IsFED;
val.IsReplacement = row.IsReplacement;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool CheckAccountTypeEligibility(string AccountCode, int CardTypeID)
{
try
{
tbl_Card_Charges Val = new DAL.tbl_Card_Charges();
using (var db = new SoneriCISEntities())
{
var aa = from cc in db.tbl_Card_Charges
join act in db.tbl_Account_Types on cc.AccountTypeID equals act.ID
where cc.IsActive == true && act.IsActive == true && act.Code == AccountCode &&
cc.CardTypeID == CardTypeID
select cc;
Val = aa.FirstOrDefault();
}
if (Val != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public tbl_Card_Charges GetCardChargeDetailsById(int CardChargeID)
{
try
{
tbl_Card_Charges Val = new DAL.tbl_Card_Charges();
using (var db = new SoneriCISEntities())
{
Val = db.tbl_Card_Charges.Include("tbl_Account_Types").Include("tbl_Card_Types").Where(a => a.ID == CardChargeID).FirstOrDefault();//using "include" because of json searializing issue
}
return(Val);
}
catch (Exception ex)
{
throw ex;
}
}
public tbl_Card_Charges GetCardChargeById(int CardChargeID)
{
try
{
tbl_Card_Charges Val = new DAL.tbl_Card_Charges();
using (var db = new SoneriCISEntities())
{
Val = db.tbl_Card_Charges.Where(a => a.ID == CardChargeID).FirstOrDefault();
}
return(Val);
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteCardCharge(int CardChargeID)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Card_Charges val = new DAL.tbl_Card_Charges();
val = db.tbl_Card_Charges.Where(a => a.ID == CardChargeID).FirstOrDefault();
val.Title = val.Title;
val.Amount = val.Amount;
val.AuthorizationComments = val.AuthorizationComments;
val.AuthorizationStatus = val.AuthorizationStatus;
val.CardTypeID = val.CardTypeID;
val.IsActive = false;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
