private void MascotaCliente()
{
conn.Open();
string sql = "select * from tblClientePets where ClienteID = " + CurrentClient.GetID();
sCommand2 = new SqlCommand(sql, conn);
sAdapter2 = new SqlDataAdapter(sCommand2);
sBuilder2 = new SqlCommandBuilder(sAdapter2);
sDs2 = new DataSet();
sAdapter2.Fill(sDs2, "ClienteID");
sTable2 = sDs2.Tables["ClieteID"];
mascotas.DataSource = sDs2.Tables["ClienteID"];
mascotas.ReadOnly = true;
mascotas.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
conn.Close();
}
private void DangerPetIndicator_OnChange(object sender, EventArgs e)
{
try
{
var petRegister = new PetRegister(CurrentClient.GetID(), CurrentPet.GetID().Value, DangerPetIndicator.Checked ? "Mascota marcada como peligrosa" : "Mascota marcada como no peligrosa", DateTime.Now, "Rojo");
if (sqlHelper.SavePetRegister(petRegister))
{
NotificationsCenter.ShowSucessMessage("Registro guardado", DangerPetIndicator.Checked ? "Mascota marcada como peligrosa" : "Mascota marcada como no peligrosa");
}
else
{
NotificationsCenter.ShowErrorMessage("Error intentando guardar el registro.");
}
handlePetRegister();
}
catch (Exception exception)
{
NotificationsCenter.ShowErrorMessageForException(exception);
}
}
private void petAddRegister_Click(object sender, EventArgs e)
{
if (PetNote.Text.Length == 0)
{
NotificationsCenter.ShowWarningMessage("Ingrese texto para el registo.");
}
try
{
var petRegister = new PetRegister(CurrentClient.GetID(), CurrentPet.GetID().Value, PetNote.Text, DateTime.Now, "Verde");
if (sqlHelper.SavePetRegister(petRegister))
{
NotificationsCenter.ShowSucessMessage("Registro guardado", "Los registros están actualizados en la base de datos.");
}
else
{
NotificationsCenter.ShowErrorMessage("Error intentando guardar el registro.");
}
}
catch (Exception exception)
{
NotificationsCenter.ShowErrorMessageForException(exception);
}
}
private void handlePay()
{
if (lista.Rows.Count == 0)
{
return;
}
pagar.Enabled = false;
foreach (DataGridViewRow row in lista.Rows)
{
int id = int.Parse(row.Cells["ID"].Value.ToString());
string product = row.Cells["Productos"].Value.ToString();
int cantidad = int.Parse(row.Cells["Cantidad"].Value.ToString());
decimal precio = decimal.Parse(row.Cells["Import"].Value.ToString());
int stock = 0;
int.TryParse(row.Cells["Inv"].Value.ToString(), out stock);
bool isService = bool.Parse(row.Cells["Servicio"].Value.ToString());
string observation = "";
if (row.Cells["Observacion"].Value != null)
{
observation = row.Cells["Observacion"].Value.ToString();
}
string shamppo = "";
int knife = 0;
if (row.Cells["Navaja"].Value != null)
{
if (!int.TryParse(row.Cells["Navaja"].Value.ToString(), out knife))
{
shamppo = row.Cells["Navaja"].Value.ToString();
}
}
if (!isService)
{
ProductItem productItem = new ProductItem(id, product, precio, cantidad, stock, isService, isService);
products.Add(productItem);
}
else
{
Service service = new Service(id, product, CurrentPet.GetID().HasValue ? CurrentPet.GetID().Value : 0, CurrentClient.GetID(), precio);
if (observation.Length > 0)
{
if (knife > 0)
{
var hairCut = new HairCut(knife, observation);
service.SetHairCutInformation(hairCut);
}
else if (shamppo.Length > 0)
{
var hairCut = new HairCut(0, observation);
service.SetHairCutInformation(hairCut);
service.setShampoo(shamppo);
}
}
services.Add(service);
}
}
printTicket();
}
private void handlePetsWithNoRegister()
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConnectionString.connectionString;
conn.Open();
try
{
SqlCommand command = new SqlCommand("insert into tblPetsRegistro values('" + CurrentPet.GetID() + "', 'Primer registro creado', 'Esta mascota ya empezó a generar historial.', 0, 'blanco', GETDATE(), GETDATE(), '" + CurrentClient.GetID() + "')", conn);
statusLabel.Text = "Registro comenzado";
command.ExecuteNonQuery();
//notificationsCenter.CreateDesktopNotification(title: "Primer registro creado", message: "Esta mascota ya empezó a generar historial.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
statusLabel.Text = "Error en el Registro";
}
}
}