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