private void deletebutton_Click(object sender, EventArgs e)
{
using (var db = new Model1())
{
var idstring = productIDbox.Text;
if (string.IsNullOrWhiteSpace(idstring))
{
MessageBox.Show("No Values has been selected for deleting");
return;
}
var id = int.Parse(idstring);
var category = db.Products.FirstOrDefault(x => x.id == id);
db.Products.Remove(category);
var sol = db.SaveChanges() > 0;
if (sol)
{
MessageBox.Show("Deleted successfully");
RateBox.Clear();
descriptionbox.Clear();
productIDbox.Clear();
quantitybox.Clear();
Namebox.Clear();
//code to refresh the data table
var found = db.Products.ToList();
productdataGridView.DataSource = found.ToDataTable();
}
}
}
public void HideTextbox()
{
if (Textbox.activeInHierarchy == true && Namebox.activeInHierarchy == true)
{
Textbox.SetActive(false);
Namebox.SetActive(false);
Hidden = true;
}
else if (Textbox2.activeInHierarchy == true)
{
Textbox2.SetActive(false);
}
else if (Textbox.activeInHierarchy == false && Namebox.activeInHierarchy == false && WrittenText != "New Text")
{
Textbox.SetActive(true);
Namebox.SetActive(true);
Hidden = false;
}
else if (Textbox2.activeInHierarchy == true)
{
Textbox2.SetActive(true);
}
Debug.Log(WrittenText);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string name, address;
int zipcode;
name = Namebox.Text;
address = Addressbox.Text;
zipcode = Convert.ToInt32(Zipcode.Text);
bool isFormValid = true;
if (name == "" || name == string.Empty)
{
MessageBox.Show("Please input your name");
Namebox.Focus();
//return;
isFormValid = false;
}
else if (address == string.Empty)
{
MessageBox.Show("Please enter your address");
isFormValid = false;
}
if (isFormValid == false)
{
return;
}
EntryForm ef = new EntryForm();
ef.Namebox = name;
ef.Addressbox = address;
ef.ZipCode = zipcode;
//string entryForm = ($"{name} lives at {address} {zipcode}");
lstApplications.Items.Add(ef);
//string name = Namebox.Text;
//Application a = new Application();
//a.Namebox = Convert.ToString(Name);
//a.Address = Convert.ToString(Address);
////a.ZipCode = Convert.ToInt32(Zipcode);
//user.Add(a);
//MessageBox.Show($"Hello {name}");
}
private void ProductFormcs_Load(object sender, EventArgs e)
{
using (var db = new Model1())
{
var category = db.Categories.ToList();
CategorycomboBox.DataSource = category.ToDataTable();
CategorycomboBox.DisplayMember = "Title";
CategorycomboBox.ValueMember = "Title";
var product = db.Products.ToList();
productdataGridView.DataSource = product.ToDataTable();
searchbox.Clear();
productIDbox.Clear();
Namebox.Clear();
descriptionbox.Clear();
quantitybox.Clear();
RateBox.Clear();
}
}
private void Addbutton_Click(object sender, EventArgs e)
{
Mapper.CreateMap <ProductDTO, Product>();
ProductDTO createProductDto = new ProductDTO();
try
{
decimal value = 0.0M;
var rest = decimal.TryParse(quantitybox.Text, out value);
if (!rest)
{
MessageBox.Show("Quantity value is incorrect");
return;
}
int result = 0;
var sol = int.TryParse(RateBox.Text, out result);
if (!sol)
{
MessageBox.Show("Rate value is incorrect");
return;
}
createProductDto.Description = descriptionbox.Text;
createProductDto.Name = Namebox.Text;
createProductDto.Quantity = value;
createProductDto.Addedby = userID;
createProductDto.AddedDate = DateTime.Now;
createProductDto.Rate = result;
createProductDto.Category = CategorycomboBox.Text;
if
(
string.IsNullOrWhiteSpace(createProductDto.Description) ||
string.IsNullOrWhiteSpace(createProductDto.Name) ||
string.IsNullOrWhiteSpace(createProductDto.Category)
)
{
MessageBox.Show("Input value cannot be empty or whitespaces");
return;
}
}
catch (Exception exception)
{
MessageBox.Show("An error occured please try again");
}
var product = Mapper.Map <ProductDTO, Product>(createProductDto);
using (var db = new Model1())
{
var val = db.Products.FirstOrDefault(c => c.Name.ToLower() == product.Name.ToLower());
if (val != null)
{
MessageBox.Show("Product already exist");
return;
}
db.Products.Add(product);
var added = db.SaveChanges() > 0;
if (added)
{
MessageBox.Show("Product added successfully");
descriptionbox.Clear();
RateBox.Clear();
quantitybox.Clear();
Namebox.Clear();
var prod = db.Products.ToList();
productdataGridView.DataSource = prod.ToDataTable();
}
}
}
