public AddEditclient(clients selectedclients)
{
InitializeComponent();
_newclients = new clients();
if (selectedclients != null)
{
_newclients = selectedclients;
mode = "Edit";
}
else
{
_newclients.clientId = -1;
foreach (clients cn in TE.clients)
{
if (_newclients.clientId < cn.clientId)
{
_newclients.clientId = cn.clientId + 11;
}
if (_newclients.clientId == cn.clientId)
{
_newclients.clientId += 11;
}
}
}
DataContext = _newclients;
}
public IHttpActionResult Putclients(int id, clients clients)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != clients.FriendID)
{
return(BadRequest());
}
db.Entry(clients).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!clientsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
static public void CreateNew(clients newClient)
{
using (var db = new StudiaProjektBazyDanychEntities())
{
db.clients.Add(newClient);
db.SaveChanges();
}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (String.IsNullOrWhiteSpace(_newclients.lname))
{
errors.AppendLine("Укажите имя клиента!");
}
if (String.IsNullOrWhiteSpace(_newclients.fname))
{
errors.AppendLine("Укажите фамилию клиента!");
}
if (String.IsNullOrWhiteSpace(_newclients.mname))
{
errors.AppendLine("Укажите отчество клиента!");
}
if (_newclients.passportId < 1)
{
errors.AppendLine("Укажите номер паспорта!");
}
if (_newclients.passportSer < 1)
{
errors.AppendLine("Укажите серию паспорта!");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (mode != "Edit")
{
TE.clients.Add(_newclients);
}
else
{
clients cl = TE.clients.Find(_newclients.clientId);
cl.lname = _newclients.fname;
cl.fname = _newclients.lname;
cl.mname = _newclients.mname;
cl.passportId = _newclients.passportId;
cl.passportSer = _newclients.passportSer;
}
try
{
TE.SaveChanges();
MessageBox.Show("Информация сохранена");
Manager.MainFrame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public IHttpActionResult Getclients(int id)
{
clients clients = db.clients.Find(id);
if (clients == null)
{
return(NotFound());
}
return(Ok(clients));
}
public void AddClient(clients client)
{
using (HotelModel context = new HotelModel())
{
if (client != null)
{
context.clients.Add(client);
context.SaveChanges();
}
}
}
public void DeleteUser_NullData_FalseReturned()
{
//Arrange
clients selectString = null;
//Act
bool check = clientsController.DeleteClientInfo(selectString);
//Assert
Assert.IsFalse(check);
}
public IHttpActionResult Postclients(clients clients)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.clients.Add(clients);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = clients.FriendID }, clients));
}
public void RemoveClient(int id)
{
using (HotelModel context = new HotelModel())
{
clients clientToRemove = context.clients.Find(id);
if (clientToRemove != null)
{
context.clients.Remove(clientToRemove);
context.SaveChanges();
}
}
}
public IHttpActionResult Deleteclients(int id)
{
clients clients = db.clients.Find(id);
if (clients == null)
{
return(NotFound());
}
db.clients.Remove(clients);
db.SaveChanges();
return(Ok(clients));
}
static public void FinalizeReclamation(clients client)
{
client.client_order_sets.Add(LocalOrder);
LocalOrder.clients = client;
LocalOrder.id_client = client.id;
LocalOrder.status = (short)ClientOrderStatus.Reclamated;
LocalOrder.order_price = 0;
using (var db = new StudiaProjektBazyDanychEntities())
{
LocalOrder.services = db.services.SingleOrDefault(t => t.service == "Reklamacja");
db.client_order_sets.Add(LocalOrder);
db.SaveChanges();
}
}
public void UpdateClient(clients client)
{
using (HotelModel context = new HotelModel())
{
clients clientToUpdate = context.clients.Find(client.IdentifiantCli);
if (clientToUpdate != null)
{
clientToUpdate.Nom = client.Nom;
clientToUpdate.Prenom = client.Prenom;
clientToUpdate.Telephone = client.Telephone;
clientToUpdate.Email = client.Email;
context.SaveChanges();
}
}
}
static public void DeleteByName(string name, string surname)
{
using (var db = new StudiaProjektBazyDanychEntities())
{
clients client = db.clients.SingleOrDefault(x => x.name == name && x.surname == surname);
var entry = db.Entry(client);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
db.clients.Attach(client);
}
db.clients.Remove(client);
db.SaveChanges();
}
}
public void AddTest_Succes()
{
var context = new tpvenlanubecalendarEntities();
clients toAdd = new clients();
toAdd.clientId = 100;
toAdd.clientName = "Charo";
toAdd.clientPicture = string.Empty;
toAdd.contactNumber = "56524";
toAdd.lastProduct = "suavizante";
toAdd.lastService = "corte";
context.clients.Add(toAdd);
context.SaveChanges();
var result = context.clients.FirstOrDefault(s => s.clientName == "Manuel");
Assert.IsNotNull(result);
}
public IHttpActionResult Getclients(int id)
{
clients clients = db.clients.Find(id);
clientViewModel rvm = new clientViewModel();
if (clients == null)
{
return(NotFound());
}
else
{
rvm.idClient = clients.idClient;
rvm.nom = clients.nom;
rvm.photo = clients.photo;
rvm.prenom = clients.prenom;
rvm.date = clients.date;
//rvm.username = clients.username;
//rvm.password = clients.password;
return(Ok(rvm));
}
}
