public bool AddCardType(tbl_Card_Types row, List <tbl_Card_Types> UpgradeCardTypes)
{
try
{
using (var db = new SoneriCISEntities())
{
if (db.tbl_Card_Types.Any(e => e.Title.ToLower() == row.Title.ToLower()))
{
throw new CustomException("Title already exists");
}
//if (db.tbl_Card_Types.Any(e => e.CardCode.ToLower() == row.CardCode.ToLower()))
// throw new CustomException("Code already exists");
db.tbl_Card_Types.Add(row);
db.SaveChanges();
//add Upgrade card types
if (UpgradeCardTypes.Count > 0)
{
AddCardUpgradeType(UpgradeCardTypes, row.ID);
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult AddUpdateCardType(tbl_Card_Types request, List <tbl_Card_Types> upgradeTypes, int?RequestId = null)
{
if (RequestId.HasValue)
{
var getSystemRequest = new SystemRequestDataAccess().GetSystemRequest(RequestId.GetValueOrDefault(), "R");
var CardTypeDetails = CardTypeMethods.GetCardTypeById(request.ID);
CardTypeDetails.tbl_Card_Upgrade_Types1 = new List <tbl_Card_Upgrade_Types>();
CardTypeDetails.tbl_Card_Charges = new List <tbl_Card_Charges>();
var existingJson = CardTypeDetails == null ? null : CustomHelper.GetJson(CardTypeDetails);
upgradeTypes.ForEach(e => request.tbl_Card_Upgrade_Types.Add(new tbl_Card_Upgrade_Types {
ParentCardType = e.ID, ChildCardType = request.ID
}));
var updatedJson = CustomHelper.GetJson(request);
tbl_System_Requests row = new tbl_System_Requests();
if (RequestId.GetValueOrDefault() <= 0)
{
row = new tbl_System_Requests
{
AuthorizationStatus = "P",
CreatorID = StateHelper.UserId,
IsActive = true,
ExistingData = existingJson,
UpdatedData = updatedJson,
RequestType = Constants.RequestTypes.CardTypes_SystemRequest
};
}
else
{
row = getSystemRequest;
row.CreatorID = StateHelper.UserId;
row.AuthorizationStatus = "P";
row.AuthorizationComments = string.Empty;
row.UpdatedData = updatedJson;
row.ExistingData = existingJson;
}
var SystemRequestFlag = (RequestId.HasValue && RequestId.GetValueOrDefault() <= 0) ? new SystemRequestDataAccess().AddSystemRequest(row) : new SystemRequestDataAccess().UpdateSystemRequest(row);
return(Json(new { IsSuccess = SystemRequestFlag, ErrorMessage = SystemRequestFlag == true ? string.Empty : CustomMessages.GenericErrorMessage, Response = SystemRequestFlag }, JsonRequestBehavior.AllowGet));
}
else
{
request.IsActive = true;
upgradeTypes = upgradeTypes ?? new List <tbl_Card_Types>();
//New Card Type
var response = request.ID <= 0 ? new CardTypesDataAccess().AddCardType(request, upgradeTypes) : new CardTypesDataAccess().UpdateCardType(request, upgradeTypes);
return(Json(new { IsSuccess = response, ErrorMessage = response == true ? string.Empty : CustomMessages.GenericErrorMessage, Response = response }, JsonRequestBehavior.AllowGet));
}
}
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);
}
}
