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); } }