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