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