public static void EditClient(ClientMVCModel client)
{
using (IDbConnection cnn = new SqlConnection(GlobalConfig.CnnString()))
{
if (client != null)
{
List <ClientModel> clients = LoadClients();
if (clients.Where(x => x.Id == client.Id).FirstOrDefault() != null)
{
var obj = new
{
PhoneNumber = client.PhoneNumber,
EmailAddress = client.EmailAddress,
Street = client.Street,
City = client.City,
PostalCode = client.PostalCode,
NIP = client.NIP,
CompanyName = client.CompanyName,
Name = client.Name,
LastName = client.LastName,
FullName = client.FullName,
Id = client.Id
};
cnn.Execute("UPDATE Clients SET " +
"NIP = @NIP, PostalCode = @PostalCode, " +
"Street = @Street, City = @City, " +
"PhoneNumber = @PhoneNumber, EmailAddress = @EmailAddress, " +
"CompanyName = @CompanyName, Name = @Name, " +
"LastName = @LastName, FullName = @FullName " +
"WHERE Id = @Id", obj);
}
}
}
}
public static ClientModel ConvertToClientModel(this ClientMVCModel model)
{
if (model == null)
{
return(new ClientModel());
}
return(new ClientModel(model.Id, model.NIP, model.PostalCode, model.City, model.Street, model.EmailAddress, model.CompanyName, model.Name, model.LastName, model.PhoneNumber));
}
// GET: Clients/Edit/5
public ActionResult Edit(int id)
{
ClientMVCModel model = SQLiteDataAccess.LoadMVCClients().Where(x => x.Id == id).FirstOrDefault();
if (model != null)
{
return(View(model));
}
return(RedirectToAction("Index"));
}
public static void SaveClient(ClientMVCModel client)
{
using (IDbConnection cnn = new SqlConnection(GlobalConfig.CnnString()))
{
var output = cnn.Query <object>($"SELECT * FROM Clients WHERE " +
$"FullName='{client.FullName}' AND " +
$"((EmailAddress='{client.EmailAddress}' AND EmailAddress!='') OR " +
$"(NIP='{client.NIP}' AND NIP!='') OR " +
$"(Street='{client.Street}' AND City='{client.City}') OR " +
$"(PhoneNumber='{client.PhoneNumber}' AND PhoneNumber!=''))",
new DynamicParameters());
if (!output.Any())
{
if (client.Company == true)
{
var obj = new
{
Name = client.Name,
LastName = client.LastName,
PhoneNumber = client.PhoneNumber,
EmailAddress = client.EmailAddress,
Street = client.Street,
City = client.City,
PostalCode = client.PostalCode,
NIP = client.NIP,
CompanyName = client.CompanyName,
FullName = client.FullName
};
cnn.Execute("insert into Clients (NIP, PostalCode, Street, City, PhoneNumber, EmailAddress, Name, LastName, FullName, CompanyName)" +
" values (@NIP, @PostalCode, @Street, @City, @PhoneNumber, @EmailAddress,@Name,@LastName, @FullName, @CompanyName)", obj);
client.Id = cnn.Query <int>("select Id from Clients").OrderBy(x => x).Last();
}
else
{
var obj = new
{
Name = client.Name,
LastName = client.LastName,
PhoneNumber = client.PhoneNumber,
EmailAddress = client.EmailAddress,
Street = client.Street,
City = client.City,
PostalCode = client.PostalCode,
FullName = client.FullName
};
cnn.Execute("insert into Clients (PostalCode, Street, City, PhoneNumber, EmailAddress, Name, LastName, FullName)" +
" values (@PostalCode, @Street, @City, @PhoneNumber, @EmailAddress,@Name,@LastName, @FullName)", obj);
client.Id = cnn.Query <int>("select Id from Clients").OrderBy(x => x).Last();
}
}
}
}
public ActionResult Edit(int id, ClientMVCModel model)
{
try
{
if (ModelState.IsValid)
{
SQLiteDataAccess.EditClient(model);
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private ClientMVCModel ConvertClientToMVCModel(ClientModel company)
{
ClientMVCModel output = new ClientMVCModel
{
PostalCode = $"{ company.Address.PostalCode.Number }",
City = $"{ company.Address.City }",
Street = $"{ company.Address.Street }",
EmailAddress = $"{ company.EmailAddress.Address }",
PhoneNumber = $"{ company.PhoneNumber.Number }",
NIP = $"{ company.NIP.Number}",
CompanyName = $"{ company.CompanyName}",
Id = company.Id
};
return(output);
}
public ActionResult Delete(int id, ClientMVCModel model)
{
try
{
if (model != null)
{
SQLiteDataAccess.RemoveClient(model.Id);
}
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(ClientMVCModel client)
{
try
{
if (ModelState.IsValid)
{
SQLiteDataAccess.SaveClient(client);
}
return(RedirectToAction("Index"));
}
catch (Exception e)
{
var errur = e.Message;
return(RedirectToAction("Create"));
}
}
private List <ClientMVCModel> GetClientsInformation(ClientMVCModel creationClient, List <int> selectedClients)
{
List <ClientMVCModel> clients = SQLiteDataAccess.LoadMVCClients();
List <ClientMVCModel> result = new List <ClientMVCModel>();
if (creationClient.PhoneNumber != null)
{
SQLiteDataAccess.SaveClient(creationClient);
if (creationClient.Company == false)
{
creationClient.NIP = "";
creationClient.CompanyName = "";
}
result.Add(creationClient);
}
foreach (int id in selectedClients)
{
result.Add(clients.Where(x => x.Id == id).FirstOrDefault());
}
return(result);
}
// GET: Clients/Create
public ActionResult Create()
{
ClientMVCModel client = new ClientMVCModel();
return(View(client));
}
