/// <summary> /// Edit department /// </summary> /// <param name="dto"></param> /// <returns></returns> public IActionResult Edit(CustomersDto dto) { if (!ModelState.IsValid) { return(Json(new { Result = "Faild", Message = GetModelStateError() })); } try { if (dto.Id == Guid.Empty) { dto.Id = Guid.NewGuid(); dto.CreatedTime = DateTime.Now; dto.ModifiedTime = DateTime.Now; } else if (dto.Id != Guid.Empty) { dto.ModifiedTime = DateTime.Now; } if (_service.InsertOrUpdate(dto)) { return(Json(new { Result = "Success" })); } return(Json(new { Result = "Faild" })); } catch (Exception ex) { return(Json(new { Result = "Faild", Message = ex.Message })); } }
public async Task <ActionResult <Customers> > PostCustomers(CustomersDto customersDto) { await _genericRepository.CreateAsync(customersDto); //.UpdateAsync(x => x.CustomerId == customerdto.CustomerId, customerdto); //.GetAsync(request); return(StatusCode(201)); //_context.Customers.Add(customers); //try //{ // await _context.SaveChangesAsync(); //} //catch (DbUpdateException) //{ // if (CustomersExists(customers.CustomerId)) // { // return Conflict(); // } // else // { // throw; // } //} //return CreatedAtAction("GetCustomers", new { id = customers.CustomerId }, customers); }
public CustomersDto SaveCustomer(CustomersDto customer) { using (var db = new GapInsuranceDBModel()) { if (!db.Clients.Any(x => x.Id == customer.ClientId)) { throw new KeyNotFoundException("Client not found"); } Customers dbCustomer = null; if (customer.Id > 0) { dbCustomer = db.Customers.FirstOrDefault(x => x.Id == customer.Id); } if (dbCustomer == null) { dbCustomer = new Customers(); db.Customers.Add(dbCustomer); } dbCustomer.FirstName = customer.FirstName; dbCustomer.LastName = customer.LastName; dbCustomer.ClientId = db.Clients.FirstOrDefault(x => x.Id == customer.ClientId).Id; db.SaveChanges(); return(Mapper.Map <Customers, CustomersDto>(dbCustomer)); } }
public bool Create(CustomersDto customer) { using (var db = GetConnection()) { db.Open(); customer.LastActiveDate = DateTime.Now; var records = db.Execute(@"INSERT INTO [dbo].[Customer] ([FirstName] ,[LastName] ,[LastActiveDate] ,[StreetAddress] ,[City] ,[State] ,[ZipCode] ,[PhoneNumber]) VALUES (@FirstName ,@LastName ,@LastActiveDate ,@StreetAddress ,@City ,@State ,@ZipCode ,@PhoneNumber)", customer); return(records == 1); } }
/// <summary> /// 转换为客户实体 /// </summary> /// <param name="dto">客户数据传输对象</param> public static Customer ToEntity(this CustomersDto dto) { if (dto == null) { return(new Customer()); } return(dto.MapTo(new Customer(dto.Id))); }
public void TestUpdateCustomer(CustomersDto customersDto) { IDatabaseConnectionHelper databaseConnectionHelper = new NorthwindDbConnectionHelper(); CustomersRepository customersRepository = new CustomersRepository(databaseConnectionHelper); var result = customersRepository.UpdateCustomer(customersDto); Assert.True(result); }
public HttpResponseMessage Put(int id, CustomersDto customer) { var repository = new CustomersRepository(); var result = repository.Edit(id, customer); return((result) ? Request.CreateResponse(HttpStatusCode.OK) : Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Could not update customer. Please try again.")); }
public IHttpActionResult Post([FromBody] CustomersDto customer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var updatedCustomer = clientManager.SaveCustomer(customer); return(Ok(updatedCustomer)); }
public HttpResponseMessage AddCustomer(CustomersDto customer) { var repo = new CustomersRepository(); var result = repo.Create(customer); if (result) { return(Request.CreateResponse(HttpStatusCode.Created)); } return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Could not create recipe, try again later...")); }
/// <summary> /// Insert New Customer /// </summary> /// <param name="customersDto"></param> /// <returns></returns> public bool InsertNewCustomer(CustomersDto customersDto) { bool result = false; string sqlCommand = @"INSERT INTO [dbo].[Customers] ([CustomerID] ,[CompanyName] ,[ContactName] ,[ContactTitle] ,[Address] ,[City] ,[Region] ,[PostalCode] ,[Country] ,[Phone] ,[Fax]) VALUES (@CustomerID ,@CompanyName ,@ContactName ,@ContactTitle ,@Address ,@City ,@Region ,@PostalCode ,@Country ,@Phone ,@Fax )" ; var dynamicParams = new DynamicParameters(); dynamicParams.Add("CustomerID", customersDto.CustomerID, DbType.String); dynamicParams.Add("CompanyName", customersDto.CompanyName, DbType.String); dynamicParams.Add("ContactName", customersDto.ContactName, DbType.String); dynamicParams.Add("ContactTitle", customersDto.ContactTitle, DbType.String); dynamicParams.Add("Address", customersDto.Address, DbType.String); dynamicParams.Add("City", customersDto.City, DbType.String); dynamicParams.Add("Region", customersDto.Region, DbType.String); dynamicParams.Add("PostalCode", customersDto.PostalCode, DbType.String); dynamicParams.Add("Country", customersDto.Country, DbType.String); dynamicParams.Add("Phone", customersDto.Phone, DbType.String); dynamicParams.Add("Fax", customersDto.Fax, DbType.String); var dbConnection = this.DatabaseConnection.Create(); using (TransactionScope scope = new TransactionScope()) { using (var conn = dbConnection) { result = conn.Execute(sqlCommand, dynamicParams) > 0; } scope.Complete(); } return(result); }
public void createCustomer() { var cman = new ClientManager(); var customer = new CustomersDto(); customer.FirstName = "Rafael"; customer.LastName = "Mercado"; customer.ClientId = 1001; cman.SaveCustomer(customer); }
public HttpResponseMessage UpdateCustomer(int customerId, CustomersDto customer) { var repository = new CustomersRepository(); var StatusResult = repository.UpdateCustomerStatus(customer.Status, customerId); if (StatusResult) { return(Request.CreateResponse(HttpStatusCode.Created)); } return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Could not update")); }
public IHttpActionResult CreateCustomers(CustomersDto customersDto) { var customer = Mapper.Map <CustomersDto, Customers>(customersDto); if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); } return(Created(new Uri(Request.RequestUri + "/" + customer.Id), customersDto)); }
public IHttpActionResult CreateCustomers(CustomersDto customersDto) { if (!ModelState.IsValid) { return(BadRequest()); } var customers = Mapper.Map <CustomersDto, Customers>(customersDto); context.Customers.Add(customers); context.SaveChanges(); customersDto.Id = customers.Id; return(Created(new Uri(Request.RequestUri + "/" + customers.Id), customersDto)); }
public CustomersDto GetCustomerById(int Id) { try { _logger.LogWarning("گرفتن کاستومر بر اساس ایدی"); var result = _client.GetStringAsync(apiUrl + "/" + Id).Result; CustomersDto customer = JsonConvert.DeserializeObject <CustomersDto>(result); return(customer); } catch (Exception) { throw; } }
public void UpdateCustomer(CustomersDto customersDto) { try { _logger.LogWarning("بروزرسانی کاستومر"); string jsonCustomer = JsonConvert.SerializeObject(customersDto); StringContent content = new StringContent(jsonCustomer, Encoding.UTF8, "application/json"); var result = _client.PutAsync(apiUrl + "/" + customersDto.Id, content).Result; } catch (Exception) { throw; } }
public IActionResult Edit(CustomersDto customersDto) { try { _logger.LogWarning("اجرای متد ویرایش کاربر باcustomersDto "); _customer.UpdateCustomer(customersDto); _logger.LogInformation("با موفقیت ویرایش شد"); return RedirectToAction("Index"); } catch (Exception) { throw; } }
public IHttpActionResult CreateCustomer(CustomersDto customerDto) { if (!ModelState.IsValid) { throw new HttpResponseException(HttpStatusCode.BadRequest); } var customer = Mapper.Map <CustomersDto, Customers>(customerDto); _context.Customers.Add(customer); _context.SaveChanges(); customerDto.Id = customer.Id; return(Created(new Uri(Request.RequestUri + "/" + customer.Id), customerDto)); }
public void UpdateCustomers(int id, CustomersDto customersDto) { if (!ModelState.IsValid) { throw new HttpResponseException(HttpStatusCode.BadRequest); } var CustomerInDb = context.Customers.SingleOrDefault(c => c.Id == id); if (CustomerInDb == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } Mapper.Map(customersDto, CustomerInDb); context.SaveChanges(); }
public ActionResult New(CustomersDto customersDto) { var customer = new Customer(); if (customersDto.Id != 0) { customer = _context.Customers.SingleOrDefault(c => c.Id == customersDto.Id); } var model = new CustomerViewModel { MemberShipTypes = _context.MemberShipTypes.ToList(), Customer = customer }; return(View("CustomerForm", model)); }
public bool AddCustomer(CustomersDto customersDto, bool res) { try { _logger.LogWarning("اضافه کردن کاستومر جدید"); string jsonCustomer = JsonConvert.SerializeObject(customersDto); StringContent content = new StringContent(jsonCustomer, Encoding.UTF8, "application/json"); var result = _client.PostAsync(apiUrl, content).Result; var isSuccessStatusCode = result.IsSuccessStatusCode; res = isSuccessStatusCode; return(res); } catch (Exception) { throw; } }
public IActionResult Login(CustomersDto login) { try { _logger.LogError("متد Login فراخوانی شد"); if (!ModelState.IsValid) { _logger.LogError("The Model is not valid"); return(View(login)); } var _client = _httpClientFactory.CreateClient("FastFoodClient"); var jsonBody = JsonConvert.SerializeObject(login); var content = new StringContent(jsonBody, Encoding.UTF8, "application/json"); var response = _client.PostAsync("/Api/Authen", content).Result; if (response.IsSuccessStatusCode) { var token = response.Content.ReadAsAsync <TokenModel>().Result; var claims = new List <Claim>() { new Claim(ClaimTypes.NameIdentifier, login.Mobile), new Claim(ClaimTypes.Name, login.Mobile), new Claim("AccessToken", token.Token) }; var identity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme); var prinsipal = new ClaimsPrincipal(identity); var properties = new AuthenticationProperties { IsPersistent = true, AllowRefresh = true }; HttpContext.SignInAsync(prinsipal, properties); _logger.LogError("کاربر توکن را دریافت و وارد شد"); return(Redirect("/Customer/Index")); } else { ModelState.AddModelError("Mobile", "User not valid or Wrong password"); return(View(login)); } } catch (Exception) { throw new BadRequestException(" خطای ناشناخته در ورود به سیستم"); } }
public IActionResult PostLogin(CustomersDto login) { _logger.LogInformation("متد Login فراخوانی شد"); var mobile = login.Mobile; var passwordCustomer = login.PasswordCustomer; if (!ModelState.IsValid) { _logger.LogError("The Model is not valid"); return(BadRequest("The Model is not valid")); } var user = _authen.ListcustomersLogin(mobile, passwordCustomer); if (user == null) { _logger.LogError("نام کاربری یا رمز عبور اشتباه است یا کاربر وجود ندارد"); return(BadRequest("Not exist user")); } if (login.Mobile != user.Mobile || login.PasswordCustomer != user.PasswordCustomer) { _logger.LogError("نام کاربری یا رمز اشتباه است"); return(Unauthorized()); } var secretKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes("1234567890 OurVerifyDotin")); var signinCredintioals = new SigningCredentials(secretKey, SecurityAlgorithms.HmacSha256); var tokenOption = new JwtSecurityToken( issuer: "http://localhost:64467", claims: new List <Claim> { new Claim(ClaimTypes.Name, login.Mobile), //new Claim(ClaimTypes.Name,login.FName), new Claim(ClaimTypes.Role, "Admin") }, expires: DateTime.Now.AddMinutes(30), signingCredentials: signinCredintioals ); _logger.LogInformation("توکن ایجاد شد"); var tokenString = new JwtSecurityTokenHandler().WriteToken(tokenOption); return(Ok(new { token = tokenString })); }
public void UpdateCustomer(int id, CustomersDto customersDto) { if (!ModelState.IsValid) { throw new HttpResponseException(HttpStatusCode.BadRequest); } var DbCustomer = _context.Customers.SingleOrDefault(c => c.Id == customersDto.Id); if (DbCustomer == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } var _customer = Mapper.Map <CustomersDto, Customers>(customersDto, DbCustomer); _context.SaveChanges(); }
public IActionResult Create(CustomersDto customers, bool res) { try { _logger.LogInformation("اجرای متد Create کاستومر"); _customer.AddCustomer(customers, res); if (res == false) { _logger.LogError("موبایل تکراری است"); return BadRequest("Mobile is Duplicate"); } _logger.LogInformation("کاربر ایجاد شد"); return RedirectToAction("Index"); } catch (Exception) { throw; } }
public bool Edit(int id, CustomersDto customer) { customer.Id = id; customer.LastActiveDate = DateTime.Now; using (var db = GetConnection()) { var numberEdited = db.Execute(@"UPDATE [dbo].[Customer] SET [FirstName] = @FirstName ,[LastName] = @LastName ,[LastActiveDate] = @LastActiveDate ,[StreetAddress] = @StreetAddress ,[City] = @City ,[State] = @State ,[ZipCode] = @ZipCode ,[PhoneNumber] = @PhoneNumber WHERE [CustomerID] = @Id", customer); return(numberEdited == 1); } }
public IHttpActionResult UpdateCustomer(int id, CustomersDto customersDto) { if (!ModelState.IsValid) { return(BadRequest()); } var customerInDB = _context.Customers.SingleOrDefault(c => c.Id == id); if (customerInDB == null) { return(NotFound()); } Mapper.Map(customersDto, customerInDB); _context.SaveChanges(); return(Ok()); }
/// <summary> /// Update Customer /// </summary> /// <param name="customersDto"></param> /// <returns></returns> public bool UpdateCustomer(CustomersDto customersDto) { bool result = false; string sqlCommand = @"UPDATE [dbo].[Customers] SET [CompanyName] = @CompanyName ,[ContactName] = @ContactName ,[ContactTitle] = @ContactTitle ,[Address] = @Address ,[City] = @City ,[Region] = @Region ,[PostalCode] = @PostalCode ,[Country] = @Country ,[Phone] = @Phone ,[Fax] = @Fax WHERE [CustomerID]= @CustomerID"; var dynamicParams = new DynamicParameters(); dynamicParams.Add("CustomerID", customersDto.CustomerID, DbType.String); dynamicParams.Add("CompanyName", customersDto.CompanyName, DbType.String); dynamicParams.Add("ContactName", customersDto.ContactName, DbType.String); dynamicParams.Add("ContactTitle", customersDto.ContactTitle, DbType.String); dynamicParams.Add("Address", customersDto.Address, DbType.String); dynamicParams.Add("City", customersDto.City, DbType.String); dynamicParams.Add("Region", customersDto.Region, DbType.String); dynamicParams.Add("PostalCode", customersDto.PostalCode, DbType.String); dynamicParams.Add("Country", customersDto.Country, DbType.String); dynamicParams.Add("Phone", customersDto.Phone, DbType.String); dynamicParams.Add("Fax", customersDto.Fax, DbType.String); var dbConnection = this.DatabaseConnection.Create(); using (TransactionScope scope = new TransactionScope()) { using (var conn = dbConnection) { result = conn.Execute(sqlCommand, dynamicParams) > 0; } scope.Complete(); } return(result); }
public void UpdateCustomer(CustomersDto customersDto) { var custDtoDemo = Mapper.Map <CustomersDto, Customers>(customersDto);//By this way we can create a customer object, access data from the DTO object and remaining is same var customerInDb = db.Customers.Find(custDtoDemo.Id); if (customerInDb == null) { throw new Exception(HttpStatusCode.NotFound.ToString()); } else { if (ModelState.IsValid) { customerInDb.BirthDate = custDtoDemo.BirthDate; customerInDb.CustomerName = custDtoDemo.CustomerName; customerInDb.MembershipTypeId = custDtoDemo.MembershipTypeId; customerInDb.IsSubscribedToNewsletter = custDtoDemo.IsSubscribedToNewsletter; db.SaveChanges(); } } }
public async Task <ActionResult> Post(CustomersDto customersDto) { if (!ModelState.IsValid) { return(BadRequest(ModelState.Values.SelectMany(v => v.Errors).Select(error => error.ErrorMessage))); } var client = _httpClientFactory.CreateClient("TEST"); using (var content = new StringContent(JsonConvert.SerializeObject(customersDto), System.Text.Encoding.UTF8, "application/json")) { HttpResponseMessage result = await client.PostAsync("Customers", content); if (result.StatusCode == System.Net.HttpStatusCode.Created) { return(Ok()); } string returnvalue = result.Content.ReadAsStringAsync().Result; throw new Exception($"Failed to PUT data : ({result.StatusCode}): {returnvalue}"); } //return new ObjectResult(new DataSourceResult { Data = new[] { product }, Total = 1 }); }