public static MsCrmResultObject GetGiftReuqestListByStatus(Guid portalId, GiftStatus giftStatus, SqlDataAccess sda) { MsCrmResultObject returnValue = new MsCrmResultObject(); try { #region | SQL QUERY | string query = @" SELECT pc.new_giftrequestId AS Id ,pc.new_name AS Name ,pc.new_potalid AS PortalId ,pc.new_potalidName AS PortalIdName ,'new_portal' AS PortalIdTypeName ,pc.new_userid AS UserId ,pc.new_useridName AS UserIdName ,'new_user' AS UserIdTypeName ,pc.new_giftid AS GiftId ,pc.new_giftidName AS GiftIdName ,'new_gift' AS GiftIdTypeName ,pc.new_point AS Point ,pc.statuscode AS Status ,pc.CreatedOn FROM new_giftrequest AS pc (NOLOCK) WHERE pc.new_potalid = '{0}' AND pc.statuscode={1} --Active"; #endregion DataTable dt = sda.getDataTable(string.Format(query, portalId, ((int)giftStatus)).ToString()); if (dt.Rows.Count > 0) { List <UserGiftRequest> giftList = dt.ToList <UserGiftRequest>(); returnValue.Success = true; returnValue.ReturnObject = giftList; } else { returnValue.Success = false; returnValue.Result = "Hediye kaydı bulunamadı!"; } } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return(returnValue); }
public async Task <ActionResult> List(GiftStatus status = GiftStatus.Approved) { User current_user = Session["user"] as User; var gifts = await _unitofWork.Gifts.GetAll( g => g.User.Id == current_user.Id && g.Status == status); gifts = gifts.OrderBy(g => g.CreatedAt).ToList(); var model = new GiftListViewModel { Gifts = gifts, GiftStatus = status, GiftStatuses = (IList <GiftStatus>)Enum.GetValues(typeof(GiftStatus)) }; return(View(model)); }
public void SeedGiftStatuses() { if (!_context.GiftStatuses.Any()) { var status1 = new GiftStatus() { StatusName = "Waiting" }; var status2 = new GiftStatus() { StatusName = "Bought" }; _context.GiftStatuses.Add(status1); _context.GiftStatuses.Add(status2); _context.SaveChanges(); } ; }
public static MsCrmResultObject GetGiftReuqestListByStatus(Guid portalId, GiftStatus giftStatus, SqlDataAccess sda) { MsCrmResultObject returnValue = new MsCrmResultObject(); try { #region | SQL QUERY | string query = @" SELECT pc.new_giftrequestId AS Id ,pc.new_name AS Name ,pc.new_potalid AS PortalId ,pc.new_potalidName AS PortalIdName ,'new_portal' AS PortalIdTypeName ,pc.new_userid AS UserId ,pc.new_useridName AS UserIdName ,'new_user' AS UserIdTypeName ,pc.new_giftid AS GiftId ,pc.new_giftidName AS GiftIdName ,'new_gift' AS GiftIdTypeName ,pc.new_point AS Point ,pc.statuscode AS Status ,pc.CreatedOn FROM new_giftrequest AS pc (NOLOCK) WHERE pc.new_potalid = '{0}' AND pc.statuscode={1} --Active"; #endregion DataTable dt = sda.getDataTable(string.Format(query, portalId, ((int)giftStatus)).ToString()); if (dt.Rows.Count > 0) { List<UserGiftRequest> giftList = dt.ToList<UserGiftRequest>(); returnValue.Success = true; returnValue.ReturnObject = giftList; } else { returnValue.Success = false; returnValue.Result = "Hediye kaydı bulunamadı!"; } } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return returnValue; }