private void purchase_btn_Click(object sender, RoutedEventArgs e)
{
int n;
bool isNumeric = int.TryParse(this.price.Text, out n);
int n2;
bool isNumeric2 = int.TryParse(this.size.Text, out n2);
if (string.IsNullOrWhiteSpace(this.pid.Text))
{
if (string.IsNullOrWhiteSpace(this.pid.Text))
{
pid.Background = Brushes.Red;
}
MessageBox.Show("Validate");
return;
}
if ((isNumeric == false) || string.IsNullOrWhiteSpace(this.category.Text) || (isNumeric2 == false) || string.IsNullOrWhiteSpace(this.color.Text) || string.IsNullOrWhiteSpace(this.brand.Text) || string.IsNullOrWhiteSpace(this.purchaseDate.Text))
{
search_btn_Click(sender, e);
if (string.IsNullOrWhiteSpace(this.pid.Text))
{
return;
}
}
saleBO sale = new saleBO();
sale.Pid = this.pid.Text;
sale.PurchaseDate = this.purchaseDate.Text;
//MessageBox.Show(item.Pid + " " + item.Price + " " + item.Category + " " + item.Size + " " + item.Color + " " + item.Brand + " " + item.Date);
saleBLL salebl = new saleBLL();
int rv = salebl.ssaleItem(sale);
if (rv == 0)
{
MessageBox.Show("Soled");
this.pid.Text = null;
this.price.Text = null;
this.category.Text = null;
this.size.Text = null;
this.color.Text = null;
this.brand.Text = null;
//this.quantity.Text = null;
}
else if (rv == 3)
{
MessageBox.Show("Product Is Not Available");
this.pid.Text = null;
}
else
{
MessageBox.Show("Error");
}
}
public int saleItem(saleBO sale)
{
DataClassesDataContext data;
string constr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\BCS DATA\Samester 6\C Sharp\Assingment 1\DAL\styloDatabase.mdf;Integrated Security=True";
using (data = new DataClassesDataContext(constr))
{
var check = from a in data.Items
where a.PID == sale.Pid
select a;
if (!check.Any())
{
return(3);
}
else
{
foreach (var s in check)
{
s.Quantity = 0;
}
}
Sale newItem = new Sale
{
PID = sale.Pid,
Sale_Date = sale.PurchaseDate
};
data.Sales.InsertOnSubmit(newItem);
try
{
data.SubmitChanges();
return(0);
}
catch (Exception e)
{
return(1);
}
}
}
public int ssaleItem(saleBO sale)
{
return(saleDal.saleItem(sale));
}
