public SQSService() { try { ServiceName = Program.ServiceName; nLogger.Log(LogLevel.Info, "AppSettings Initializing"); var appSettings = ConfigurationManager.AppSettings; nLogger.Log(LogLevel.Info, "AppSettings Initialized"); sellerInfo = new SellerInfo(); sellerInfo.QueueUrl = appSettings["queueUrl"]; sellerInfo.SqsServiceUrl = appSettings["sqsServiceUrl"]; sellerInfo.MwsServiceUrl = appSettings["mwsServiceUrl"]; sellerInfo.MwsAuthToken = appSettings["mwsAuthToken"]; sellerInfo.UpdatePrices = bool.Parse(appSettings["updatePrices"]); sellerInfo.BatchSize = int.Parse(appSettings["batchSize"]); sellerInfo.BatchWaitTimeSec = int.Parse(appSettings["batchWaitTimeSec"]); sellerInfo.FeedSize = int.Parse(appSettings["feedSize"]); sellerInfo.BetweenFeedWaitTimeSec = int.Parse(appSettings["betweenFeedWaitTimeSec"]); consumer = new SQSConsumer(sellerInfo, nLogger, dataRepository); } catch (Exception ex) { nLogger.Log(LogLevel.Error, ex); Stop(); } }
public async Task <Unit> Handle(AddSellerCommand request, CancellationToken cancellationToken) { var userInfo = await _ebayService.GetUser(request.UserName); if (userInfo != null) { var seller = new SellerInfo { EmailAddress = userInfo.Email?.Contains("@") ?? false ? userInfo.Email : null, EbaySellerUserName = userInfo.UserName.ToLower(), Address1 = userInfo.Street, Address2 = userInfo.Street1, Address3 = userInfo.Street2, City = userInfo.City, State = userInfo.State, Zip = userInfo.Zip, DateAdded = userInfo.RegistrationDate, FirstName = userInfo.FirstName, LastName = userInfo.LastName, LastProcessDate = DateTime.UtcNow, }; _sellerRepo.Add(seller); await _uow.SaveEntitiesAsync(); } return(Unit.Value); }
public List <SellerInfo> SelectByParentSellerID(SellerInfo sellerInfo) { string SQLServerConnectString = "Data Source=localhost;Initial Catalog=WebAPPDevDotNETFinnalTest;Integrated Security=True;Pooling=False"; SqlConnection SQLConnection = new SqlConnection(SQLServerConnectString); string SQLCommandText = "SELECT * FROM [dbo].[SellerInfo] WHERE ParentSellerID=@ParentSellerID"; SqlCommand SQLCommand = new SqlCommand(SQLCommandText, SQLConnection); SQLCommand.Parameters.Add(new SqlParameter("@ParentSellerID", sellerInfo.ParentSellerID)); DataSet dataSet = new DataSet(); SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(SQLCommand); SQLConnection.Open(); SQLDataAdapter.Fill(dataSet); SQLConnection.Close(); List <SellerInfo> SelectResult = new List <SellerInfo>(); for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { SellerInfo temp = new SellerInfo(); temp.SellerID = Int32.Parse(dataSet.Tables[0].Rows[i]["SellerID"].ToString()); temp.ParentSellerID = Int32.Parse(dataSet.Tables[0].Rows[i]["ParentSellerID"].ToString()); temp.Level = dataSet.Tables[0].Rows[i]["Level"].ToString(); temp.Phone = dataSet.Tables[0].Rows[i]["Phone"].ToString(); temp.Name = dataSet.Tables[0].Rows[i]["Name"].ToString(); temp.Provience = dataSet.Tables[0].Rows[i]["Provience"].ToString(); temp.City = dataSet.Tables[0].Rows[i]["City"].ToString(); temp.Address = dataSet.Tables[0].Rows[i]["Address"].ToString(); SelectResult.Add(temp); } return(SelectResult); }
public SellerInfo SelectOne(SellerInfo sellerInfo) { string SQLServerConnectString = "Data Source=localhost;Initial Catalog=WebAPPDevDotNETFinnalTest;Integrated Security=True;Pooling=False"; SqlConnection SQLConnection = new SqlConnection(SQLServerConnectString); string SQLCommandText = "SELECT * FROM [dbo].[SellerInfo] WHERE SellerID=@SellerID"; SqlCommand SQLCommand = new SqlCommand(SQLCommandText, SQLConnection); SQLCommand.Parameters.Add(new SqlParameter("@SellerID", sellerInfo.SellerID)); DataSet dataSet = new DataSet(); SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(SQLCommand); SQLConnection.Open(); SQLDataAdapter.Fill(dataSet); SQLConnection.Close(); SellerInfo SelectResult = new SellerInfo(); if (dataSet.Tables[0].Rows.Count == 0) { return(null); } SelectResult.SellerID = Int32.Parse(dataSet.Tables[0].Rows[0]["SellerID"].ToString()); SelectResult.ParentSellerID = Int32.Parse(dataSet.Tables[0].Rows[0]["ParentSellerID"].ToString()); SelectResult.Level = dataSet.Tables[0].Rows[0]["Level"].ToString(); SelectResult.Phone = dataSet.Tables[0].Rows[0]["Phone"].ToString(); SelectResult.Name = dataSet.Tables[0].Rows[0]["Name"].ToString(); SelectResult.Provience = dataSet.Tables[0].Rows[0]["Provience"].ToString(); SelectResult.City = dataSet.Tables[0].Rows[0]["City"].ToString(); SelectResult.Address = dataSet.Tables[0].Rows[0]["Address"].ToString(); return(SelectResult); }
public ActionResult MainView() { var user = GetUser(); string msg; var list = BuyerInfoBll.GetSellerList(user.BuyerId, out msg); if (list != null) { if (list.Count == 0) { return(RedirectToAction("NoSeller")); } if (list.Count == 1) { SellerInfo sellerInfo = list.FirstOrDefault(); if (sellerInfo != null) { return(RedirectToAction("ShowSellersGoods", new { sellerId = sellerInfo.SellerId })); } } } return(View(user)); }
/// <summary> /// 登录页面 /// </summary> /// <returns></returns> public ActionResult Login() { string name = string.Empty; string pwd = string.Empty; if (!string.IsNullOrEmpty(Request.Form["name"])) { name = Request.Form["name"]; } if (!string.IsNullOrEmpty(Request.Form["name"])) { pwd = Request.Form["pwd"]; } if (!string.IsNullOrEmpty(name) && !string.IsNullOrEmpty(pwd)) { string error = string.Empty; SellerInfo model = new SellerInfo(); SellerInfoBll.RequestLogin(name, pwd, out model, out error); if (!string.IsNullOrEmpty(error)) { Response.Write("<script>alert('" + error + "');</script>"); //Response.Redirect("/UserCenter/Login"); } else { HttpCookie cookie = new HttpCookie("userId"); cookie.Value = model.SellerId.ToString(); cookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(cookie); Session["UserId"] = model.SellerId; Response.Redirect("/BackStage/Index"); } } return(View()); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowIndex == GridView1.EditIndex && e.Row.RowIndex != -1) { (e.Row.FindControl("DropDownListLevel") as DropDownList).Text = (e.Row.FindControl("TextBoxLevel") as TextBox).Text; (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataTextField = "Name"; (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataValueField = "SellerID"; (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataSource = (new BLL_SellerInfo()).SelectAll(true); (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataBind(); (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).Text = (e.Row.FindControl("TextBoxParentSellerID") as TextBox).Text; } else if (e.Row.RowType == DataControlRowType.Footer) { (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataTextField = "Name"; (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataValueField = "SellerID"; (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataSource = (new BLL_SellerInfo()).SelectAll(true); (e.Row.FindControl("DropDownListParentSellerID") as DropDownList).DataBind(); } if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == -1) { SellerInfo temp = (new BLL_SellerInfo()).SelectOne(Int32.Parse((e.Row.FindControl("LabelParentSellerID") as Label).Text)); if (temp != null) { (e.Row.FindControl("LabelParentSellerID") as Label).Text = temp.Name; } else { (e.Row.FindControl("LabelParentSellerID") as Label).Text = "SellerID:" + (e.Row.FindControl("LabelParentSellerID") as Label).Text; } } }
protected SellerInfo sInfo = null; // 商家 protected void bind() { if (id <= 0) { Response.Write("<script>alert('参数错误');history.go(-1);</script>"); Response.End(); } info = BLL.goodsBLL.GetModel(id); if (info == null || info.GoodsId != id) { Response.Write("<script>alert('无对应的商品');history.go(-1);</script>"); Response.End(); } name = info.GoodsName; if (info.sellerid <= 0) { Response.Write("<script>alert('无对应的商家信息');history.go(-1);</script>"); Response.End(); } sInfo = BLL.SellerBLL.GetModel(info.sellerid); if (sInfo == null || sInfo.sellerid != info.sellerid) { Response.Write("<script>alert('无对应的商家信息');history.go(-1);</script>"); Response.End(); } }
public ActionResult Create(ProductListViewModel listproductObj) { //ProductListViewModel listproductObj = new ProductListViewModel(); Product productObj = new Product(); var fileName = String.Empty; List <ProductGrid> gridInfo = new List <ProductGrid>(); try { // null chr=eck if (listproductObj.productImage != null && listproductObj.productImage.ContentLength > 0) { //var fileName = Path.GetFileName(file.FileName); fileName = Guid.NewGuid().ToString() + System.IO.Path.GetExtension(listproductObj.productImage.FileName); var uploadUrl = Server.MapPath("~/Upload"); listproductObj.productImage.SaveAs(Path.Combine(uploadUrl, fileName)); } // todo - check existing product productObj.ProductName = listproductObj.ProductName; //var CheckProductName = dbOBJ.ProductsTable.Where(x => x.ProductName == productObj.ProductName).FirstOrDefault(); if (dbOBJ.ProductsTable.Any(x => x.ProductName == productObj.ProductName)) { return(View("ExistingProductInfo")); } else { productObj.CashOnDelevery = listproductObj.CashOnDelevery; int catId = Convert.ToInt32(listproductObj.SelectedCategory); productObj.Category = dbOBJ.CatagoriesTable.Where(x => x.CategoryID == catId).FirstOrDefault(); productObj.Price = listproductObj.Price; productObj.ImagePath = fileName; Product product = dbOBJ.ProductsTable.Add(productObj); foreach (var sellerId in listproductObj.SelectedSellers) { SellerInfo sellerInfoObj = new SellerInfo(); sellerInfoObj.Seller = dbOBJ.SellerTable.Where(x => x.SellerID == sellerId).FirstOrDefault(); sellerInfoObj.Product = product; dbOBJ.sellerInfoTable.Add(sellerInfoObj); } dbOBJ.SaveChanges(); listproductObj.CatagoryList = GetCategories(); listproductObj.SellerList = GetSellers(); //listproductObj.gridinfo = GetGridData(); gridInfo = GetGridData(); } } catch (Exception ex) { ViewBag.Message = "Data svaed Failure"; } return(View("ProductGrid", gridInfo)); }
public void Delete(int SellerID) { SellerInfo sellerInfo = new SellerInfo(); sellerInfo.SellerID = SellerID; DAL_SellerInfo SellerInfoDAL = new DAL_SellerInfo(); SellerInfoDAL.Delete(sellerInfo); }
public List <SellerInfo> SelectByParentSellerID(int ParentSellerID) { SellerInfo sellerInfo = new SellerInfo(); sellerInfo.ParentSellerID = ParentSellerID; DAL_SellerInfo SellerInfoDAL = new DAL_SellerInfo(); return(SellerInfoDAL.SelectByParentSellerID(sellerInfo)); }
public SellerInfo SelectOne(int SellerID) { SellerInfo sellerInfo = new SellerInfo(); sellerInfo.SellerID = SellerID; DAL_SellerInfo SellerInfoDAL = new DAL_SellerInfo(); return(SellerInfoDAL.SelectOne(sellerInfo)); }
public async Task <ActionResult> SellerRegister(SellerRegisterViewModel model, HttpPostedFileBase FrontImage, HttpPostedFileBase BackImage) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email, FirstName = model.Fname, LastName = model.Lname, PhoneNumber = model.PhoneNo }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { var newseller = new SellerInfo() { ID = user.Id, NationalID = model.NationalID, BusinessName = model.BusinessName, }; db.SellerInfo.Add(newseller); db.SaveChanges(); await UserManager.AddToRoleAsync(user.Id, "seller"); string newimg = user.Id.ToString() + "." + FrontImage.FileName.Split('.')[1]; FrontImage.SaveAs(Server.MapPath("~/SellerInfoImgs/") + newimg); newseller.FrontImage = newimg; string new2img = user.Id.ToString() + "." + BackImage.FileName.Split('.')[1]; BackImage.SaveAs(Server.MapPath("~/SellerInfoImgs/") + new2img); newseller.BackImage = new2img; db.SaveChanges(); var newInventory = new Inventory() { ID = newseller.ID, BuildingNum = model.BuildingNum, Street = model.Street, City = model.City, LandLineNum = model.LandLineNum }; db.Inventories.Add(newInventory); db.SaveChanges(); await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); return(RedirectToAction("InventoryManagement", "Seller")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View("sellerRegister", model)); }
public async Task <IActionResult> Post([FromBody] SellerInfo seller) { if ((int)this.userRepo.ExecuteOperation("ExistsLogin", new[] { new KeyValuePair <string, object>("login", seller.Login) }) == 1) { throw new System.Exception("Username already exists"); } var res = await this.repo.ExecuteOperationAsync("CreateSeller", new[] { new KeyValuePair <string, object>("name", seller.Name), new KeyValuePair <string, object>("email", seller.Email), new KeyValuePair <string, object>("cellphone", seller.CellPhone), new KeyValuePair <string, object>("address", seller.Address), new KeyValuePair <string, object>("login", seller.Login), new KeyValuePair <string, object>("password", MyCryptography.Encrypt(seller.Password)) }); return(Ok(res)); }
public string GetSellerUserInfo() { string errMsg = string.Empty; SellerInfo model = SellerInfoBll.GetModel(int.Parse(Request.Cookies["userId"].Value), out errMsg); if (model != null) { model.MobilePhone = model.MobilePhone.Substring(0, 3) + "****" + model.MobilePhone.Substring(model.MobilePhone.Length - 4, 4); } return(JsonConvert.SerializeObject(model)); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { SellerInfo temp = (new BLL_SellerInfo()).SelectOne(Int32.Parse((GridView1.SelectedRow.FindControl("LabelSellerID") as Label).Text)); ChoosedSellerID = temp.SellerID; GridView2.Caption = "经销商 " + temp.Name + " 的用户"; GridView2.ShowFooter = false; GridView2.EditIndex = -1; ButtonInsert2.Visible = true; GridView2_FetchData(); }
public async Task <IActionResult> Put(int id, [FromBody] SellerInfo seller) { var userId = GetCurrentUserId(); if (userId == ((SellerInfo)(await this.repo.ExecuteOperationAsync("GetSeller", new[] { new KeyValuePair <string, object>("id", id) }))).UserId) { await this.repo.ExecuteOperationAsync("UpdateSeller", new[] { new KeyValuePair <string, object>("id", id), new KeyValuePair <string, object>("name", seller.Name ?? DBNull.Value.ToString()), new KeyValuePair <string, object>("cellphone", seller.CellPhone ?? DBNull.Value.ToString()), new KeyValuePair <string, object>("address", seller.Address ?? DBNull.Value.ToString()), new KeyValuePair <string, object>("email", seller.Email ?? DBNull.Value.ToString()), new KeyValuePair <string, object>("password", MyCryptography.Encrypt(seller.Password) ?? DBNull.Value.ToString()) }); return(await this.GetById(id)); } return(NotFound()); }
public void Delete(SellerInfo sellerInfo) { string SQLServerConnectString = "Data Source=localhost;Initial Catalog=WebAPPDevDotNETFinnalTest;Integrated Security=True;Pooling=False"; SqlConnection SQLConnection = new SqlConnection(SQLServerConnectString); string SQLCommandText = "DELETE [dbo].[SellerInfo] where [SellerID] = @SellerID"; SqlCommand SQLCommand = new SqlCommand(SQLCommandText, SQLConnection); SQLCommand.Parameters.Add(new SqlParameter("@SellerID", sellerInfo.SellerID)); SQLConnection.Open(); SQLCommand.ExecuteNonQuery(); SQLConnection.Close(); }
protected override void OnLoad(EventArgs e) { sellerinfo = getsellerinfo(sellerid); if (sellerinfo == null || sellerid <= 0) { Response.Write("<script language='javascript'>window.location.href = '/seller/login.html?fromurl=" + HttpContext.Current.Request.Url.AbsoluteUri + "';</script>"); Response.End(); } uname = sellerinfo.uname; name = sellerinfo.name; base.OnLoad(e); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { SellerUser temp1 = (new BLL_SellerUser()).SelectOne(Int32.Parse(e.Row.Cells[1].Text)); if (temp1 != null) { e.Row.Cells[1].Text = temp1.UserName; } else { e.Row.Cells[1].Text = "UserID:" + e.Row.Cells[1].Text; } Model temp2 = (new BLL_Model()).SelectOne(Int32.Parse(e.Row.Cells[3].Text)); if (temp2 != null) { e.Row.Cells[3].Text = temp2.ModelName; } else { e.Row.Cells[3].Text = "ModelID:" + e.Row.Cells[3].Text; } Brand temp4 = (new BLL_Brand()).SelectOne(temp2.BrandID); if (temp4 != null) { e.Row.Cells[2].Text = temp4.BrandName; } else { e.Row.Cells[2].Text = "BrandID:" + temp2.BrandID; } if (Int32.Parse(e.Row.Cells[6].Text) == -1) { e.Row.Cells[6].Text = "-"; } else { SellerInfo temp3 = (new BLL_SellerInfo()).SelectOne(Int32.Parse(e.Row.Cells[6].Text)); if (temp3 != null) { e.Row.Cells[6].Text = temp3.Name; } else { e.Row.Cells[6].Text = "SellerID:" + e.Row.Cells[6].Text; } } } }
public SellerInfo getsellerinfo(int sellerid) { //memberInfo Entity = memberBLL.memberEntity; //if (Entity != null && Entity.uid.Trim().Length > 0) //{ // return Entity; //} if (sellerid > 0) { SellerInfo Entity = BLL.SellerBLL.GetModel(sellerid); return(Entity); } return(null); }
public void New(string Name, string Provience, string City, string Address, string Phone, int ParentSellerID, string Level) { SellerInfo sellerInfo = new SellerInfo(); sellerInfo.Name = Name; sellerInfo.Provience = Provience; sellerInfo.City = City; sellerInfo.Address = Address; sellerInfo.Phone = Phone; sellerInfo.ParentSellerID = ParentSellerID; sellerInfo.Level = Level; DAL_SellerInfo SellerInfoDAL = new DAL_SellerInfo(); SellerInfoDAL.Insert(sellerInfo); }
static void Main(string[] args) { Adress adress = new Adress { City = "Sofia", StreetNameNumber = "Vidin", Postcode = "M204AL", }; SellerInfo sellerInfo = new SellerInfo { SellerAge = 30, SellerName = "Ivan", }; SellerExp sellerExp = new SellerExp { DaysCount = 24, MonthsCount = 12, YearsCount = 4, }; // Creating a List of Products List <Product> Products = new List <Product> { new Product { ProductName = "Bear", ProductPrice = 22.30M, ProductWeight = 333.21, ExpDate = new DateTime(2026, 3, 1, 7, 0, 0) }, new Product { ProductName = "Dino", ProductPrice = 12.55M, ProductWeight = 310.52, ExpDate = new DateTime(2022, 5, 5, 1, 0, 0) } }; Console.WriteLine("Here you can buy:"); Console.WriteLine(Products[1].ProductName); Console.WriteLine("For the price of:"); Console.WriteLine(Products[1].ProductPrice); Console.WriteLine("From our Seller: "); Console.WriteLine(sellerInfo.SellerName); }
public static SellerInfoDto ToDto(this SellerInfo sellerInfo) { if (sellerInfo == null) { return(null); } return(new SellerInfoDto { Id = sellerInfo.Id, BankAccountNumber = sellerInfo.BankAccountNumber, ContactEmail = sellerInfo.ContactEmail, PhoneNumber = sellerInfo.PhoneNumber, AdditionalInfo = sellerInfo.AdditionalInfo }); }
/// <summary> /// 修改密码保存 /// </summary> /// <returns></returns> public string ChangePwd() { string newValue = string.Empty; string oldValue = string.Empty; if (!string.IsNullOrEmpty(Request.Form["oldPwd"])) { oldValue = Request.Form["oldPwd"]; } if (!string.IsNullOrEmpty(Request.Form["newPwd"])) { newValue = Request.Form["newPwd"]; } if (!string.IsNullOrEmpty(oldValue) && !string.IsNullOrEmpty(newValue)) { string errMsg = string.Empty; SellerInfo model = SellerInfoBll.GetModel(int.Parse(Request.Cookies["userId"].Value), out errMsg); if (model != null) { if (model.Password == oldValue) { model.Password = newValue; if (SellerInfoBll.Update(model)) { return("修改成功"); } else { return("修改失败"); } } else { return("原密码不正确"); } } else { return("请重新登录后操作"); } } else { return("参数信息出错,请重试"); } }
public IActionResult GetAllInformation(PersonalCenter info) { DBHelper dBHelper = new DBHelper(); try { if (info.UserType == "CUSTOMER") { UserInfo res = new UserInfo(); string Sql = @"SELECT ID,USER_NAME,ADDRESS,DATE_OF_REG,PHONE_NUMBER,PHOTO FROM CUSTOMER WHERE ID =" + info.ID; DataTable table = dBHelper.ExecuteTable(Sql); DataRow row = table.Rows[0]; res.ID = row["ID"].ToString(); res.UserName = row["USER_NAME"].ToString(); res.Address = row["ADDRESS"].ToString(); res.RegDate = row["DATE_OF_REG"].ToString(); res.PhoneNumber = row["PHONE_NUMBER"].ToString(); res.Image = dBHelper.GetCustomerBlob(info.ID); return(Ok(dBHelper.ToJson(res))); } else if (info.UserType == "SELLER") { SellerInfo res = new SellerInfo(); string Sql = @"SELECT ID,SELLER_NAME,ADDRESS,DATE_OF_REG,PHONE_NUMBER,EARNING,PHOTO FROM SELLER WHERE ID =" + info.ID; DataTable table = dBHelper.ExecuteTable(Sql); DataRow row = table.Rows[0]; res.ID = row["ID"].ToString(); res.SellerName = row["SELLER_NAME"].ToString(); res.Address = row["ADDRESS"].ToString(); res.RegDate = row["DATE_OF_REG"].ToString(); res.Income = double.Parse(row["EARNING"].ToString()); res.Image = dBHelper.GetSellerBlob(info.ID); res.PhoneNumber = row["PHONE_NUMBER"].ToString(); return(Ok(dBHelper.ToJson(res))); } return(BadRequest("未知的错误发生了")); } catch (OracleException) { return(BadRequest("数据库请求错误")); } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { SellerInfo sellerInfo = new SellerInfo(); sellerInfo.SellerID = Convert.ToInt32((GridView1.Rows[e.RowIndex].FindControl("LabelSellerID") as Label).Text); sellerInfo.Name = (GridView1.Rows[e.RowIndex].FindControl("TextBoxName") as TextBox).Text; sellerInfo.Provience = (GridView1.Rows[e.RowIndex].FindControl("TextBoxProvience") as TextBox).Text; sellerInfo.City = (GridView1.Rows[e.RowIndex].FindControl("TextBoxCity") as TextBox).Text; sellerInfo.Phone = (GridView1.Rows[e.RowIndex].FindControl("TextBoxPhone") as TextBox).Text; sellerInfo.Address = (GridView1.Rows[e.RowIndex].FindControl("TextBoxAddress") as TextBox).Text; sellerInfo.Level = (GridView1.Rows[e.RowIndex].FindControl("DropDownListLevel") as DropDownList).Text; sellerInfo.ParentSellerID = Convert.ToInt32((GridView1.Rows[e.RowIndex].FindControl("DropDownListParentSellerID") as DropDownList).Text); (new BLL_SellerInfo()).Update(sellerInfo.SellerID, sellerInfo.Name, sellerInfo.Provience, sellerInfo.City, sellerInfo.Address, sellerInfo.Phone, sellerInfo.ParentSellerID, sellerInfo.Level); GridView1.EditIndex = -1; GridView1_FetchData(); }
// GET: BackStage public ActionResult Index() { ViewBag.menu = GetMenuList(); //ViewBag.UserName = "******"; if (Request.Cookies["userId"] != null && !string.IsNullOrEmpty(Request.Cookies["userId"].Value)) { string errMsg = string.Empty; SellerInfo model = SellerInfoBll.GetModel(int.Parse(Request.Cookies["userId"].Value), out errMsg); ViewBag.UserName = model.CompanyName; //ViewBag.phone = model.MobilePhone.Substring(0,3)+"****"+model.MobilePhone.Substring(model.MobilePhone.Length-4,4); } else { Response.Redirect("/UserCenter/Login"); } return(View()); }
public async Task <Unit> Handle(CreateOrUpdateSellerInfoCommand request, CancellationToken cancellationToken) { var userId = _httpContext.User.Claims.ToTokenPayload().UserClaims.Id; var sellerInfo = await _sellerInfoRepository.GetByUserIdAsync(userId); var sellerInfoExists = sellerInfo != null; if (!sellerInfoExists) { sellerInfo = new SellerInfo(userId, request.ContactEmail, request.PhoneNumber, request.BankAccountNumber); if (request.AdditionalInfo != null) { sellerInfo.SetAdditionalInfo(request.AdditionalInfo); } _sellerInfoRepository.Add(sellerInfo); } else { if (request.ContactEmail != null) { sellerInfo.SetContactEmail(request.ContactEmail); } if (request.PhoneNumber != null) { sellerInfo.SetPhoneNumber(request.PhoneNumber); } if (request.BankAccountNumber != null) { sellerInfo.SetBankAccountNumber(request.BankAccountNumber); } if (request.AdditionalInfo != null) { sellerInfo.SetAdditionalInfo(request.AdditionalInfo); } } if (sellerInfoExists) { _sellerInfoRepository.Update(sellerInfo); } await _sellerInfoRepository.UnitOfWork.SaveChangesAndDispatchDomainEventsAsync(cancellationToken); return(await Unit.Task); }
public void Insert(SellerInfo sellerInfo) { string SQLServerConnectString = "Data Source=localhost;Initial Catalog=WebAPPDevDotNETFinnalTest;Integrated Security=True;Pooling=False"; SqlConnection SQLConnection = new SqlConnection(SQLServerConnectString); string SQLCommandText = "INSERT INTO [dbo].[SellerInfo] ([Phone], [Provience], [City], [Address], [Name], [Level], [ParentSellerID]) VALUES (@Phone, @Provience, @City, @Address, @Name, @Level, @ParentSellerID)"; SqlCommand SQLCommand = new SqlCommand(SQLCommandText, SQLConnection); SQLCommand.Parameters.Add(new SqlParameter("@Phone", sellerInfo.Phone)); SQLCommand.Parameters.Add(new SqlParameter("@Provience", sellerInfo.Provience)); SQLCommand.Parameters.Add(new SqlParameter("@City", sellerInfo.City)); SQLCommand.Parameters.Add(new SqlParameter("@Address", sellerInfo.Address)); SQLCommand.Parameters.Add(new SqlParameter("@Name", sellerInfo.Name)); SQLCommand.Parameters.Add(new SqlParameter("@Level", sellerInfo.Level)); SQLCommand.Parameters.Add(new SqlParameter("@ParentSellerID", sellerInfo.ParentSellerID)); SQLConnection.Open(); SQLCommand.ExecuteNonQuery(); SQLConnection.Close(); }