public static void UpdateUserBalance(Guid userId, CurrenciesEnum currency, double balanceAddition, UpdateBalanceType updateType)
{
try
{
using (var ctx = new RentooloEntities())
{
var obj = ctx.Wallets.FirstOrDefault(x => x.UserId == userId && x.CurrencyId == (int)currency);
if (obj != null)
{
obj.Value = obj.Value + balanceAddition;
}
else
{
Wallets wallet = new Wallets();
wallet.Value = balanceAddition;
wallet.UserId = userId;
wallet.CurrencyId = (int)currency;
wallet.CreateDate = DateTime.Now;
ctx.Wallets.Add(wallet);
}
ctx.SaveChanges();
}
}
catch (System.Exception ex)
{
DataHelper.AddException(ex);
}
}
public static void SubmitArticle(Articles item)
{
using (var ctx = new RentooloEntities())
{
if (item.Id == 0)
{
ctx.Articles.Add(item);
}
else
{
var obj = ctx.Articles.Single(x => x.Id == item.Id);
obj.WhenDate = item.WhenDate;
obj.Head = item.Head;
obj.Text = item.Text;
obj.UserId = item.UserId;
}
try
{
ctx.SaveChanges();
}
catch (System.Exception ex)
{
DataHelper.AddException(ex);
}
}
}
public static void SubmitNewsVark(NewsVark item)
{
using (var ctx = new RentooloEntities())
{
if (item.Id == 0)
{
ctx.NewsVark.Add(item);
}
else
{
var obj = ctx.NewsVark.Single(x => x.Id == item.Id);
obj.Date = item.Date;
obj.Text = item.Text;
obj.CreateDate = item.CreateDate;
obj.AuthorId = item.AuthorId;
obj.Active = item.Active;
}
try
{
ctx.SaveChanges();
}
catch (System.Exception ex)
{
DataHelper.AddException(ex);
}
}
}
/// <summary>
/// Добавление значения статистики
/// Client = 0 - обращение с сайта
/// Client = 1 - обращение с клиента
/// </summary>
public static void AddLoginStatistic(LoginStatistics item)
{
using (var ctx = new RentooloEntities())
{
if (string.IsNullOrEmpty(item.Version))
{
item.Version = string.Empty;
}
var obj = ctx.LoginStatistics.FirstOrDefault(x => x.UserName == item.UserName && x.Ip == item.Ip && x.Client == item.Client && x.Version == item.Version);
if (obj != null)
{
obj.Count++;
obj.WhenLastDate = item.WhenLastDate;
}
else
{
ctx.LoginStatistics.Add(item);
}
try
{
ctx.SaveChanges();
}
catch (System.Exception ex)
{
DataHelper.AddException(ex);
}
}
}
public static void AddPayment(Payments item)
{
using (var ctx = new RentooloEntities())
{
ctx.Payments.Add(item);
ctx.SaveChanges();
}
}
public static void AddAuctionRequest(AuctionRequests auctionRequest)
{
using (var ctx = new RentooloEntities())
{
ctx.AuctionRequests.Add(auctionRequest);
ctx.SaveChanges();
}
}
public static void AddRates(Rates model)
{
using (var ctx = new RentooloEntities())
{
ctx.Rates.Add(model);
ctx.SaveChanges();
}
}
public static void AddReferral(Referrals item)
{
using (var ctx = new RentooloEntities())
{
ctx.Referrals.Add(item);
ctx.SaveChanges();
}
}
public static void AddComment(Comments comment)
{
using (var dc = new RentooloEntities())
{
dc.Comments.Add(comment);
dc.SaveChanges();
}
}
public static void CreateTender(Tenders tender)
{
using (var dc = new RentooloEntities())
{
dc.Tenders.Add(tender);
dc.SaveChanges();
}
}
public static void SetWinTenderRequest(int tRequestId)
{
using (var dc = new RentooloEntities())
{
dc.TenderRequest.First(x => x.Id == tRequestId).DateWin = DateTime.Now;
dc.SaveChanges();
}
}
public static void AddRentRequest(Rent auctionRequest)
{
using (var ctx = new RentooloEntities())
{
ctx.Rent.Add(auctionRequest);
ctx.SaveChanges();
}
}
public static void CreateTenderRequest(TenderRequest request)
{
using (var dc = new RentooloEntities())
{
dc.TenderRequest.Add(request);
dc.SaveChanges();
}
}
/// <summary>
/// Проведение операции
/// </summary>
public static void AddOperation(Operations operation)
{
using (var ctx = new RentooloEntities())
{
ctx.Operations.Add(operation);
ctx.SaveChanges();
}
}
// comment id
public static void UpdateCommentDisLikes(int id)
{
using (var dc = new RentooloEntities())
{
dc.Comments.First(x => x.Id == id).DisLikes += 1;
dc.SaveChanges();
}
}
public static void UpdateTReqStatusEnd(int tRequestId)
{
using (var dc = new RentooloEntities())
{
dc.TenderRequest.First(x => x.Id == tRequestId).DateStart = DateTime.Now;
dc.SaveChanges();
}
}
public static void AddTokensBuying(TokensBuying item)
{
using (var ctx = new RentooloEntities())
{
ctx.TokensBuying.Add(item);
ctx.SaveChanges();
}
}
public static void UpdateAuction(Auctions newItem, int oldItemId)
{
using (var ctx = new RentooloEntities())
{
var updatedItem = ctx.Auctions.First(x => x.Id == oldItemId);
UpdateAllAuctionFields(updatedItem, newItem);
ctx.SaveChanges();
}
}
public static void UnBlockUser(Guid userId)
{
using (var dc = new RentooloEntities())
{
Memberships obj = dc.Memberships.Single(x => x.UserId == userId);
obj.IsLockedOut = false;
dc.SaveChanges();
}
}
public static void UpdateCashIn(int Id, int state)
{
using (var ctx = new RentooloEntities())
{
var obj = ctx.CashIns.Single(x => x.Id == Id);
obj.WhenDate = DateTime.Now;
ctx.SaveChanges();
}
}
public static void UpdateSettingByName(Settings item)
{
using (var ctx = new RentooloEntities())
{
var obj = ctx.Settings.FirstOrDefault(x => x.Name == item.Name);
obj.Value = item.Value;
ctx.SaveChanges();
}
}
public static void SetUserLastActivityDate(Guid userId)
{
using (var dc = new RentooloEntities())
{
Users obj = dc.Users.Single(x => x.UserId == userId);
obj.LastActivityDate = DateTime.Now;
dc.SaveChanges();
}
}
public static void SetUserLastActivityDateByUserName(string userName)
{
using (var dc = new RentooloEntities())
{
Users obj = dc.Users.Single(x => x.UserName == userName);
obj.LastActivityDate = DateTime.Now;
dc.SaveChanges();
}
}
public static void UpdateRent(Rent newItem, int oldItemId)
{
using (var ctx = new RentooloEntities())
{
var updatedItem = ctx.Rent.First(x => x.Id == oldItemId);
UpdateAllRentFields(updatedItem, newItem);
ctx.SaveChanges();
}
}
public static long AddAdvert(Adverts item)
{
using (var dc = new RentooloEntities())
{
var result = dc.Adverts.Add(item);
var res = dc.SaveChanges();
return(result.Id);
}
}
public static long AddRent(Rent item)
{
using (var ctx = new RentooloEntities())
{
ctx.Rent.Add(item);
ctx.SaveChanges();
return(item.Id);
}
}
public static void UpdateUser(Users user)
{
using (var ctx = new RentooloEntities())
{
var obj = ctx.Users.FirstOrDefault(x => x.UserId == user.UserId);
obj.Pwd = user.Pwd;
obj.PublicId = user.PublicId;
obj.Communication = user.Communication;
ctx.SaveChanges();
}
}
public static long AddCraftsMan(CraftsMan item)
{
using (var dc = new RentooloEntities())
{
var result = dc.CraftsMan.Add(item);
var res = dc.SaveChanges();
return(result.Id);
}
}
public static void UpdateCashOut(int Id, int state, string comment)
{
using (var ctx = new RentooloEntities())
{
var obj = ctx.CashOuts.Single(x => x.Id == Id);
obj.State = state;
obj.Comment = comment;
obj.WhenAdminEvent = DateTime.Now;
ctx.SaveChanges();
}
}
// used if customer didnt like tender which had done
public static void UpdateTReqStatusDelDates(int tRequestId)
{
using (var dc = new RentooloEntities())
{
var tRequest = dc.TenderRequest.First(x => x.Id == tRequestId);
tRequest.DateStart = null;
tRequest.DateCompleted = null;
tRequest.DateDelivered = null;
dc.SaveChanges();
}
}
