public BlogModel CreatePost(BlogModel post) { post.Date = DateTime.Now; context.Blog.Add(post); context.SaveChanges(); return(post); }
public ActionResult Create([Bind(Include = "RoleId,roleName")] Role role) { if (ModelState.IsValid) { db.Roles.Add(role); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(role)); }
public ActionResult Create([Bind(Include = "MessageID,Datetime,MessageText,UserId")] Message message) { if (ModelState.IsValid) { db.Messages.Add(message); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(message)); }
public ActionResult Create([Bind(Include = "UserID,Name,Password,RoleId,Email")] User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public static void DBObjectsData(DBContent content) { if (!content.SportGoods.Any()) { content.SportGoods.AddRange( new SportsViewModel { name = "М'яч для американського футболу", description = "Select American Football Pro №5 Brown (5703543078905)", img = "М'яч для американського футболу.jpg", price = 812, }, new SportsViewModel { name = "Ракетка для настільного тенісу", description = "Atemi 2000 (87274175417)", img = "Ракетка настільного тенісу.jpg", price = 1000, }, new SportsViewModel { name = "Баскетбольне Кільце", description = "Корзина TARMAK (100 x 48 x 2,3 см) Чорний", img = "Баскетбольное Кольцо.jpg", price = 3700, } ); } content.SaveChanges(); }
/// <summary> /// 修改意向订单状态 /// </summary> /// <param name="id">订单id</param> /// <param name="userId">用户</param> /// <param name="remarks"></param> /// <param name="businessOrderFlag"></param> /// <param name="isUser">标志是否是用户操作</param> /// <returns></returns> public string UpdateIntentionOrderFlag(Guid id, Guid userId, string remarks, BusinessOrderFlag businessOrderFlag, bool isUser = false) { var intentionOrder = baseDal.GetItemById(id); if (businessOrderFlag == BusinessOrderFlag.Effective) //确认有效操作 { intentionOrder.Id = id; intentionOrder.Flag = (int)businessOrderFlag; intentionOrder.IntentionReceiveUserId = userId; intentionOrder.ReceiveTime = DateTime.Now; intentionOrder.ReceiveRemarks = remarks; intentionOrder.FinalRecordUserId = userId; intentionOrder.FinalRecordRemarks = remarks; intentionOrder.FinalRecordTime = DateTime.Now; baseDal.UpdateItem(intentionOrder); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.IsOk); } } else if (businessOrderFlag == BusinessOrderFlag.Invalid) //无效操作 { intentionOrder.Id = id; intentionOrder.Flag = (int)businessOrderFlag; if (isUser) { intentionOrder.Remarks = "用户取消 :" + remarks; } else { intentionOrder.FinalRecordUserId = userId; intentionOrder.FinalRecordRemarks = remarks; intentionOrder.FinalRecordTime = DateTime.Now; } baseDal.UpdateItem(intentionOrder); UserOrder userOrder = new UserOrder() { Id = intentionOrder.OrderId, Flag = (int)OrderStateFlag.UserTermination, CancelTime = DateTime.Now }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CancelTime }); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.IsOk); } } return(BReturnModel.Error); }
public void AddToCart(MusicInstance instance) { string shopCartId = session.GetString("CartId"); if (_dBContent.ShopCartItems.Where(i => i.instance.Id == instance.Id && i.ShopCartId == shopCartId).Any()) { return; } _dBContent.ShopCartItems.Add(new ShopCartItem { instance = instance, ShopCartId = ShopCartId }); ; _dBContent.SaveChanges(); }
/// <summary> /// 用户提交 意向单业务 /// </summary> /// <param name="orderId">关联的 流程订单id</param> /// <param name="userId">提交意向的 用户id</param> /// <param name="remarks">意向备注</param> /// <param name="bProductDetailModel">意向产品 集合</param> /// <returns></returns> public string AddIntentionOrder(Guid orderId, Guid userId, string remarks, IList <BProductDetailModel> bProductDetailModel) { var isHave = baseDal.GetListQuery(item => item.OrderId == orderId).Count(); if (isHave > 0) { return("该流程订单已经存在 对应的意向订单 请勿重复提交"); } IntentionOrder intentionOrder = new IntentionOrder() { Id = Guid.NewGuid(), CreateTime = DateTime.Now, Flag = (int)BusinessOrderFlag.Undetermined, OrderId = orderId, IntentionUserId = userId, Remarks = remarks }; baseDal.Add(intentionOrder); foreach (var item in bProductDetailModel) { IntentionProduct intentionProduct = new IntentionProduct() { Id = Guid.NewGuid(), Count = item.Count, Specifications = item.Specifications, Manufactor = item.Manufactor, Name = item.ProductName, Price = item.Price, IntentionOrderId = intentionOrder.Id, Remarks = item.Remarks }; intentionProductDal.Add(intentionProduct); } UserOrder userOrder = new UserOrder() { Id = intentionOrder.OrderId, Flag = (int)OrderStateFlag.Intention, //OrderId = "1", CurrentStateTime = DateTime.Now }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CurrentStateTime }); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.IsOk); } return(BReturnModel.Error); }
public void AddElementi(InfoCar Car) { dBContent.danniyeKorzini.Add( new DanniyeKorzini { IdKorzini = IdKorzini, Cars = Car, price = Car.Price, Image = Car.Image }); dBContent.SaveChanges(); }
/// <summary> /// 修改 询价单状态业务 /// </summary> /// <param name="orderId">业务订单id</param> /// <param name="userId">修改用户id</param> /// <param name="remarks">修改备注</param> /// <param name="ConfirmerTime">报价时间</param> /// <param name="businessOrderFlag">状态码</param> /// <returns>处理消息</returns> public string UpdateInquiryOrderFlag(Guid id, Guid userId, string remarks, BusinessOrderFlag businessOrderFlag, DateTime?ConfirmerTime = null) { int count = 0; if (businessOrderFlag == BusinessOrderFlag.Effective) { var inquiryOrderModel = baseDal.GetItemById(id); if (inquiryOrderModel.Flag == (int)BusinessOrderFlag.Undetermined) //该询价单为待确认订单 { inquiryOrderModel.Flag = (int)businessOrderFlag; inquiryOrderModel.ConfirmerUserId = userId; inquiryOrderModel.ConfirmerTime = ConfirmerTime; inquiryOrderModel.ConfirmerRemarks = remarks; } baseDal.UpdateItem(inquiryOrderModel); count = DBContent.SaveChanges(); //count = baseDal.UpdateList(item => item.Id == id, update => new InquiryOrder() { Flag = (int)businessOrderFlag, ConfirmerUserId = userId, ConfirmerRemarks = remarks, ConfirmerTime = ConfirmerTime }); } else if (businessOrderFlag == BusinessOrderFlag.Invalid) { var inquiryOrderModel = baseDal.GetItemById(id); if (inquiryOrderModel.Flag == (int)BusinessOrderFlag.Undetermined) //该询价单为待确认订单 { inquiryOrderModel.Flag = (int)businessOrderFlag; inquiryOrderModel.ConfirmerRemarks = remarks; } baseDal.UpdateItem(inquiryOrderModel); UserOrder userOrder = new UserOrder() { Id = inquiryOrderModel.OrderId, Flag = (int)OrderStateFlag.InquiryInvalid, //OrderId = "1", CancelTime = DateTime.Now, CurrentStateTime = DateTime.Now }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CancelTime, UserOrderPropertiesConfig.CurrentStateTime }); count = DBContent.SaveChanges(); } if (count > 0) { return(BReturnModel.IsOk); } return(BReturnModel.Error); }
/// <summary> /// 用户 提交询价单业务 /// </summary> /// <param name="userId">用户id</param> /// <param name="productName">产品名称</param> /// <param name="remarks">备注</param> /// <param name="price">用户提交的参考价格</param> /// <param name="productImgList">用户提交的 图片路径数组</param> /// <param name="orderFlag">订单状态 此处提交(询价单 状态码)</param> /// <param name="price">支付状态 此处提交(未支付)</param> /// <returns></returns> public bool AddUserInquiryOrder(Guid userId, string remarks, decimal price, List <string> productImgList, OrderStateFlag orderFlag = OrderStateFlag.Inquiry, OrderPayStateFlag payFlag = OrderPayStateFlag.Unpaid) { UserOrder userOrder = new UserOrder() { Id = Guid.NewGuid(), UserId = userId, OriginalPrice = price, RealisticPrice = price, Flag = (int)orderFlag, PayFlag = (int)payFlag, CreateTime = DateTime.Now, BusinessOrderId = OrderHelp.GetOrderIdOne(4), Description = remarks }; userOrderDal.Add(userOrder); InquiryOrder inquiryOrder = new InquiryOrder() { Id = Guid.NewGuid(), CreateTime = DateTime.Now, Price = price, OrderId = userOrder.Id, Remarks = remarks, Flag = (int)BusinessOrderFlag.Undetermined, UserId = userId }; baseDal.Add(inquiryOrder); foreach (var urlItem in productImgList) { InquiryProductImg inquiryProductImg = new InquiryProductImg() { Id = Guid.NewGuid(), ImgUrl = urlItem, OrderId = userOrder.Id, Remarks = remarks, InquiryOrdertId = inquiryOrder.Id }; inquiryProductImgDal.Add(inquiryProductImg); } int count = DBContent.SaveChanges(); if (count > 0) { return(true); } return(false); }
public IActionResult UpdateInstance(EditInstanceViewModel editInstance) { Console.WriteLine(editInstance.EditInstanceObj.Id); Console.WriteLine(editInstance.EditInstanceObj.Title); Console.WriteLine(editInstance.EditInstanceObj.Price); MusicInstance instance = _dbContent.MusicInstances .FirstOrDefault(i => i.Id == editInstance.EditInstanceObj.Id); instance.Title = editInstance.EditInstanceObj.Title; instance.Price = Convert.ToUInt16(editInstance.EditInstanceObj.Price); _dbContent.MusicInstances.Update(instance); _dbContent.SaveChanges(); return(Redirect("Index")); }
public void sozdaniyeZakaza(Zakaz zakaz) { zakaz.Date = DateTime.Now; _dBContent.dbZakaza.Add(zakaz); var items = _korzina.spisokdannix; foreach (var el in items) { var NoviyZakaz = new ElementiZakaza() { CarId = el.Cars.Id, IdZakaza = zakaz.Id }; _dBContent.dbElementiZakaza.Add(NoviyZakaz); } _dBContent.SaveChanges(); }
/// <summary> /// 修改用户地址 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateUserAddress(UserAddress model) { var userAddress = baseDal.GetListQuery(item => item.Id == model.Id && item.UserId == model.UserId).FirstOrDefault(); //检查该地址是否属于 当前登陆的用户 if (userAddress != null) { model.Id = userAddress.Id; //限定id model.UserId = userAddress.UserId; //限定用户id baseDal.UpdateItem(model); int count = DBContent.SaveChanges(); if (count > 0) { return(true); } } return(false); }
public ActionResult Signup(User user) { DBContent db = new DBContent(); int count = db.Users.Where(u => u.Name.Equals(user.Name)).Count(); if (count != 0) { ModelState.AddModelError("Name", "Name is not available"); } if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); Account account = new Account(); account.Login = user.Name; account.Password = user.Password; return(Login(account)); } return(View()); }
/// <summary> /// 修改 合同单状态 /// </summary> /// <param name="id">合同单id</param> /// <param name="userId">操作用户id</param> /// <param name="remarks">备注</param> /// <param name="businessOrderFlag">需要修改的状态</param> /// <returns></returns> public BReturnModel UpdateContractOrderFlag(Guid id, Guid userId, string remarks, BusinessOrderFlag businessOrderFlag, bool isUser = false) { var contractOrder = baseDal.GetItemById(id); if (contractOrder == null) { return(BReturnModel.ReturnError("合同单不存在 请提交正确的id")); } if (isUser) //当前修改为用户操作 { if (contractOrder.UserId != userId) { return(BReturnModel.ReturnError("当前合同单 不属于当前操作用户")); } if (businessOrderFlag == BusinessOrderFlag.Invalid) //用户 取消合同单 { contractOrder.Flag = (int)BusinessOrderFlag.Invalid; baseDal.UpdateItem(contractOrder); UserOrder userOrder = new UserOrder() { Id = contractOrder.OrderId, CancelTime = DateTime.Now, Flag = (int)OrderStateFlag.UserCancelContract }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CancelTime }); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.ReturnOk()); } return(BReturnModel.ReturnError("没有更新数据")); } else if (businessOrderFlag == BusinessOrderFlag.Effective) //用户确认合同 { contractOrder.Flag = (int)BusinessOrderFlag.Effective; contractOrder.ReceiveTime = DateTime.Now; baseDal.UpdateItem(contractOrder); UserOrder userOrder = new UserOrder() { Id = contractOrder.OrderId, CancelTime = DateTime.Now, Flag = (int)OrderStateFlag.SignContract, ReceiveTime = DateTime.Now }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CancelTime, UserOrderPropertiesConfig.ReceiveTime }); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.ReturnOk()); } return(BReturnModel.ReturnError("没有更新数据")); } } else //当前为 业务员操作 { if (businessOrderFlag == BusinessOrderFlag.Invalid) //业务员 取消合同单 { contractOrder.Flag = (int)BusinessOrderFlag.Invalid; baseDal.UpdateItem(contractOrder); UserOrder userOrder = new UserOrder() { Id = contractOrder.OrderId, CancelTime = DateTime.Now, Flag = (int)OrderStateFlag.UserCancelContract }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CancelTime }); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.ReturnOk()); } return(BReturnModel.ReturnError("没有更新数据")); } } return(BReturnModel.ReturnOk()); }
public Genre CteateGenre(Genre genre) { dBContent.Add(genre); dBContent.SaveChanges(); return(genre); }
public ActionResult Create(Note note) { db.Notes.Add(note); db.SaveChanges(); return(RedirectToAction("Note")); }
public Game CteateGame(Game game) { dBContent.Add(game); dBContent.SaveChanges(); return(game); }
public SportsViewModel CreatePost(SportsViewModel post) { dbContent.SportGoods.Add(post); dbContent.SaveChanges(); return(post); }
/// <summary> /// 添加/制作 合同单 /// </summary> /// <param name="orderId"></param> /// <param name="makeUserId"></param> /// <param name="expireTime"></param> /// <param name="bProductDetailModel"></param> /// <returns></returns> public BReturnModel AddContractOrder(Guid orderId, Guid makeUserId, DateTime expireTime, IList <BProductDetailModel> bProductDetailModel) { var isHave = baseDal.GetListQuery(item => item.OrderId == orderId).Count(); if (isHave > 0) { return(BReturnModel.ReturnError("当前流程单 已经存在对应的合同订单 不可重复提交")); } var userOrderModel = userOrderDal.GetItemById(orderId); if (userOrderModel == null) { return(BReturnModel.ReturnError("未找到 对应的流程订单")); } ContractOrder contractOrder = new ContractOrder() { Id = Guid.NewGuid(), CreateTime = DateTime.Now, Flag = (int)BusinessOrderFlag.Undetermined, ExpireTime = expireTime, OrderId = orderId, ContractMakeUserId = makeUserId, UserId = userOrderModel.UserId }; baseDal.Add(contractOrder); decimal totalPrice = 0; foreach (var item in bProductDetailModel) { ContractProduct contractProduct = new ContractProduct() { Id = Guid.NewGuid(), ContractOrderId = contractOrder.Id, Count = item.Count, Price = item.Price, ProductName = item.ProductName, Remarks = item.Remarks, Specifications = item.Specifications, Manufactor = item.Manufactor }; totalPrice += (decimal)contractProduct.Price * (int)contractProduct.Count; contractProductDal.Add(contractProduct); } UserOrder userOrder = new UserOrder() { Id = orderId, CurrentStateTime = DateTime.Now, Flag = (int)OrderStateFlag.Contract, OriginalPrice = totalPrice, RealisticPrice = totalPrice //现价 需要减去用户红包金额 }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CurrentStateTime, UserOrderPropertiesConfig.OriginalPrice, UserOrderPropertiesConfig.RealisticPrice }); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.ReturnOk()); } else { return(BReturnModel.ReturnError()); } }
/// <summary> /// 添加 报价订单 /// </summary> /// <param name="userId">操作员id</param> /// <param name="orderId">关联的流程订单id</param> /// <param name="remarks">备注</param> /// <param name="QuotationUserId">操作员id</param> /// <param name="expireTime">过期时间</param> /// <param name="bProductDetailModel">关联的产品模型</param> /// <returns>响应消息</returns> public BReturnModel AddQuotationOrder(Guid orderId, string remarks, Guid QuotationUserId, DateTime expireTime, IList <BProductDetailModel> bProductDetailModel) { var isHave = baseDal.GetListQuery(item => item.OrderId == orderId).Count(); if (isHave > 0) { return(BReturnModel.ReturnError("orderId流程订单已经存在 对应的报价订单 请勿重复提交")); } var userOrderModel = userOrderDal.GetItemById(orderId); if (userOrderModel == null) { return(BReturnModel.ReturnError("未查询到 对应的流程订单")); } QuotationOrder quotationOrder = new QuotationOrder() { Id = Guid.NewGuid(), CreateTime = DateTime.Now, ExpireTime = expireTime, Remarks = remarks, OrderId = orderId, QuotationUserId = QuotationUserId, Flag = (int)BusinessOrderFlag.Undetermined, UserId = userOrderModel.UserId }; baseDal.Add(quotationOrder); foreach (var item in bProductDetailModel) { QuotationProduct quotationProduct = new QuotationProduct() { Id = Guid.NewGuid(), Manufactor = item.Manufactor, Specifications = item.Specifications, QuotationOrderId = quotationOrder.Id, Price = item.Price, Remarks = item.Remarks, ProductName = item.ProductName, }; quotationProductDal.Add(quotationProduct); foreach (var itemImg in item.ImgUrl) { QuotationProductImg quotationProductImg = new QuotationProductImg() { Id = Guid.NewGuid(), ImgUrl = itemImg, QuotationProductId = quotationProduct.Id }; quotationProductImgDal.Add(quotationProductImg); } } UserOrder userOrder = new UserOrder() { Id = orderId, Flag = (int)OrderStateFlag.Offer, CurrentStateTime = DateTime.Now }; userOrderDal.UpdateItemSelect(userOrder, new string[] { UserOrderPropertiesConfig.Flag, UserOrderPropertiesConfig.CurrentStateTime }); int count = DBContent.SaveChanges(); if (count > 0) { return(BReturnModel.ReturnOk()); } return(BReturnModel.ReturnError()); }