protected void BtnNew_Click(object sender, EventArgs e)
{
ClearAll();
GridView1.DataSource = null;
clsReceive Dal = new clsReceive();
DataSet obj = new DataSet();
obj = Dal.GenerateNewReceiveId();
txtRecId.Text = (obj.Tables[0].Rows[0][0]).ToString();
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
BLayer.Receive obj = InitalizeObject();
clsReceive Dal = new clsReceive();
Dal.UpdateReceive(obj);
Dal.UpdateProductDetail(obj);
LoadGrid();
ClearAll();
}
private void LoadManuf()
{
clsReceive Dal = new clsReceive();
DataSet Manuf = Dal.FillManufacturer();
ddlProdManfacturer.DataTextField = "ManufacturerName";
ddlProdManfacturer.DataValueField = "ManufacturerID";
ddlProdManfacturer.DataSource = Manuf.Tables[0];
ddlProdManfacturer.DataBind();
ddlProdManfacturer.Items.Insert(0, "--Please Make Selection--");
ddlProdManfacturer.Items[0].Value = "0";
}
private void LoadSupplier()
{
clsReceive Dal = new clsReceive();
DataSet supplier = Dal.FillSupplier();
ddlSupplier.DataTextField = "SupplierName";
ddlSupplier.DataValueField = "SupplierId";
ddlSupplier.DataSource = supplier.Tables[0];
ddlSupplier.DataBind();
ddlSupplier.Items.Insert(0, "--Please Make Selection--");
ddlSupplier.Items[0].Value = "0";
}
protected void BtnSave_Click(object sender, EventArgs e)
{
//BLayer.Receive obj = InitalizeObject();
//receives.Add(obj);
//LoadGridinMemory();
//ClearAll();
clsReceive Dal = new clsReceive();
BLayer.Receive obj = InitalizeObject();
Dal.AddNewReceive(obj);
Dal.AddNewProductDetail(obj);
LoadGrid();
clearAfterSave();
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
clsReceive Dal = new clsReceive();
string Recid = txtRecId.Text;
bool IsPriced = Dal.IsProductsGotPrice(Recid);
if (IsPriced == false)
{
Dal.DeleteReceive(Recid);
Dal.DeleteReceiveDetail(Recid);
ClearAll();
GridView1.DataSource = null;
GridView1.DataBind();
}
else
{
errorLabel.Text = " you are unable to delete. Those products ready for sale";
}
}
private void FindReceiveByRecId(string recId)
{
clsReceive Dal = new clsReceive();
DataSet recevie = Dal.LoadReceiveFromDB(recId);
GridView1.DataSource = recevie.Tables[0];
GridView1.DataBind();
decimal total = recevie.Tables[0].AsEnumerable().Sum(row => row.Field <decimal>("UnitCost"));
if (total != 0)
{
GridView1.FooterRow.Cells[5].Text = "Total";
GridView1.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right;
GridView1.FooterRow.Cells[6].Text = total.ToString("N2");
}
else
{
errorLabel.Text = "No Record related to this Id";
}
}
