protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_Purchase inv_Purchase = new Inv_Purchase();
inv_Purchase = Inv_PurchaseManager.GetInv_PurchaseByID(Int32.Parse(Request.QueryString["inv_PurchaseID"]));
Inv_Purchase tempInv_Purchase = new Inv_Purchase();
tempInv_Purchase.Inv_PurchaseID = inv_Purchase.Inv_PurchaseID;
tempInv_Purchase.PurchaseName = txtPurchaseName.Text;
tempInv_Purchase.PurchseDate = txtPurchseDate.Text;
tempInv_Purchase.SuppierID = Int32.Parse(ddlSuppier.SelectedValue);
tempInv_Purchase.InvoiceNo = txtInvoiceNo.Text;
tempInv_Purchase.Particulars = txtParticulars.Text;
tempInv_Purchase.IsPurchase = cbIsPurchase.Checked;
tempInv_Purchase.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
tempInv_Purchase.ExtraField1 = txtExtraField1.Text;
tempInv_Purchase.ExtraField2 = txtExtraField2.Text;
tempInv_Purchase.ExtraField3 = txtExtraField3.Text;
tempInv_Purchase.ExtraField4 = txtExtraField4.Text;
tempInv_Purchase.ExtraField5 = txtExtraField5.Text;
tempInv_Purchase.AddedBy = getLogin().LoginID;
tempInv_Purchase.AddedDate = DateTime.Now;
tempInv_Purchase.UpdatedBy = getLogin().LoginID;
tempInv_Purchase.UpdatedDate = DateTime.Now;
tempInv_Purchase.RowStatusID = 1;
bool result = Inv_PurchaseManager.UpdateInv_Purchase(tempInv_Purchase);
Response.Redirect("AdminInv_PurchaseDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_Purchase inv_Purchase = new Inv_Purchase();
inv_Purchase.PurchaseName = txtPurchaseName.Text;
inv_Purchase.PurchseDate = txtPurchseDate.Text;
inv_Purchase.SuppierID = Int32.Parse(ddlSuppier.SelectedValue);
inv_Purchase.InvoiceNo = txtInvoiceNo.Text;
inv_Purchase.Particulars = txtParticulars.Text;
inv_Purchase.IsPurchase = cbIsPurchase.Checked;
inv_Purchase.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_Purchase.ExtraField1 = txtExtraField1.Text;
inv_Purchase.ExtraField2 = txtExtraField2.Text;
inv_Purchase.ExtraField3 = txtExtraField3.Text;
inv_Purchase.ExtraField4 = txtExtraField4.Text;
inv_Purchase.ExtraField5 = txtExtraField5.Text;
inv_Purchase.AddedBy = getLogin().LoginID;
inv_Purchase.AddedDate = DateTime.Now;
inv_Purchase.UpdatedBy = getLogin().LoginID;
inv_Purchase.UpdatedDate = DateTime.Now;
inv_Purchase.RowStatusID = 1;
int resutl = Inv_PurchaseManager.InsertInv_Purchase(inv_Purchase);
Response.Redirect("AdminInv_PurchaseDisplay.aspx");
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = Inv_PurchaseManager.DeleteInv_Purchase(Convert.ToInt32(linkButton.CommandArgument));
showInv_PurchaseGrid();
}
protected void btnDeletePurchase_Click(object sender, EventArgs e)
{
if (Inv_PurchaseManager.DeleteInv_Purchase(int.Parse(txtID.Text)))
{
makeAllTheLinkInvisible();
lblDeleteMessage.Visible = true;
lblDeleteMessage.Text = "Deleted Successfully..";
}
}
private void showInv_IssueDetailGrid()
{
Inv_Purchase purchase = Inv_PurchaseManager.GetInv_PurchaseByID(int.Parse(Request.QueryString["PurchaseID"]));
txtParticulars.Text = purchase.Particulars;
txtInvoiceNo.Text = purchase.InvoiceNo;
txtPurchseDate.Text = purchase.PurchseDate.ToString("dd MMM yyyy");
lblPurchaseID.Text = purchase.Inv_PurchaseID.ToString();
ddlSupplier.SelectedValue = purchase.SuppierID.ToString();
hfSupplier.Value = purchase.SuppierID.ToString();
hfJournalMasterID.Value = purchase.ExtraField2;
}
private void showInv_PurchaseData()
{
Inv_Purchase inv_Purchase = new Inv_Purchase();
inv_Purchase = Inv_PurchaseManager.GetInv_PurchaseByID(Int32.Parse(Request.QueryString["inv_PurchaseID"]));
txtPurchaseName.Text = inv_Purchase.PurchaseName;
txtPurchseDate.Text = inv_Purchase.PurchseDate;
ddlSuppier.SelectedValue = inv_Purchase.SuppierID.ToString();
txtInvoiceNo.Text = inv_Purchase.InvoiceNo;
txtParticulars.Text = inv_Purchase.Particulars;
cbIsPurchase.Checked = inv_Purchase.IsFeature;
ddlWorkSatation.SelectedValue = inv_Purchase.WorkSatationID.ToString();
txtExtraField1.Text = inv_Purchase.ExtraField1;
txtExtraField2.Text = inv_Purchase.ExtraField2;
txtExtraField3.Text = inv_Purchase.ExtraField3;
txtExtraField4.Text = inv_Purchase.ExtraField4;
txtExtraField5.Text = inv_Purchase.ExtraField5;
txtAddedBy.Text = inv_Purchase.AddedBy.ToString();
txtUpdatedBy.Text = inv_Purchase.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_Purchase.UpdatedDate;
ddlRowStatus.SelectedValue = inv_Purchase.RowStatusID.ToString();
}
private void showInv_PurchaseGrid()
{
gvInv_Purchase.DataSource = Inv_PurchaseManager.GetAllInv_Purchases();
gvInv_Purchase.DataBind();
}
private void loadData()
{
int suppliyerID = 0;
try
{
suppliyerID = Int32.Parse(Request.QueryString["SuppliyerID"]);
}
catch (Exception ex)
{
suppliyerID = 0;
}
string fromDate = (Request.QueryString["FromDate"] != null ? Request.QueryString["FromDate"].ToString() : "");
string toDate = (Request.QueryString["ToDate"] != null ? Request.QueryString["ToDate"].ToString() : "");
//purchase info
string sql = " and (Inv_Purchase.PurchseDate between '" + fromDate + "' and '" + toDate + "')";
if (suppliyerID != 0)
{
sql += " and Inv_Purchase.SuppierID =" + suppliyerID;
}
List <Inv_Purchase> purchases = Inv_PurchaseManager.GetAllInv_PurchasesByDateNSupplierID(sql);
string htmlTable = "";
foreach (Inv_Purchase purchase in purchases)
{
htmlTable += @"<table width='800px' style='margin-bottom:50px;'><tr>
<td>
<table style='border:1px solid Black;width:100%;' >
<tr>
<td style='width:100px;' class='PurchaseHeaderCss'>Purchase Date</td>
<td style='width:5px;'>:</td>
<td>
" + purchase.PurchseDate.ToString("dd-MMM-yyyy") + @"
</td>
</tr>
<tr>
<td class='PurchaseHeaderCss'>Purchase ID</td>
<td>:</td>
<td>
" + purchase.Inv_PurchaseID.ToString() + @"
</td>
</tr>
<tr>
<td class='PurchaseHeaderCss'>Invoice No.</td>
<td>:</td>
<td>
" + purchase.InvoiceNo + @"
</td>
</tr>
<tr>
<td class='PurchaseHeaderCss'>Supplier Name</td>
<td>:</td>
<td>
" + purchase.SupplierName + @"
</td>
</tr>
<tr >
<td class='PurchaseHeaderCss'>Particulars</td>
<td>:</td>
<td>
" + purchase.Particulars + @"
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>";
//Item Info
List <Inv_Item> items = new List <Inv_Item>();
items = Inv_ItemManager.GetAllInv_ItemsByPurchaseID(purchase.Inv_PurchaseID);
htmlTable += @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
<tr id='tableHeader'>
<td style='border-left:0px;'>S/L</td>
<td>Product Code</td>
<td>Product Name</td>
<td>Quantity</td>
<td>Unit</td>
<td>Price</td>
<td>Amount</td>
</tr>";
int lastRawMaterialID = 0;
decimal Total = 0;
decimal Subtotal = 0;
decimal TotalAmount = 0;
decimal SubtotalAmount = 0;
int serialNo = 1;
foreach (Inv_Item item in items)
{
if (lastRawMaterialID != 0 && lastRawMaterialID != item.RawMaterialID)
{
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + Subtotal.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + SubtotalAmount.ToString("0,0.00") + @"</td>
</tr>";
Subtotal = 0;
SubtotalAmount = 0;
}
if (lastRawMaterialID != item.RawMaterialID)
{
lastRawMaterialID = item.RawMaterialID;
htmlTable += @"<tr>
<td colspan='7' style='padding-left:50px; border-top:1px solid black;border-bottom:1px solid black;font-weight:bold;'>
Item: " + item.RawMaterialName + @"
</td>
</tr>";
}
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
<td>" + item.ItemCode + @"</td>
<td>" + item.ItemName + @"</td>
<td style='text-align:right;'>" + item.PurchasedQuantity.ToString("0,0.00") + @"</td>
<td >" + item.QuantityUnitName + @"</td>
<td style='text-align:right;'>" + item.PricePerUnit.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + item.PurchasedQuantityPrice.ToString("0,0.00") + @"</td>
</tr>";
Subtotal += item.PurchasedQuantity;
SubtotalAmount += item.PurchasedQuantityPrice;
Total += item.PurchasedQuantity;
TotalAmount += item.PurchasedQuantityPrice;
}
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + Subtotal.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + SubtotalAmount.ToString("0,0.00") + @"</td>
</tr>";
htmlTable += @"<tr id='lastRow'>
<td> </td>
<td> </td>
<td>Grand Total</td>
<td>" + Total.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + TotalAmount.ToString("0,0.00") + @"</td>
</tr></table></td></tr></table></hr>";
}
lblItemList.Text = htmlTable;
}
private void loadData()
{
int PurchaseID = int.Parse(Request.QueryString["PurchaseID"]);
//purchase info
Inv_Purchase purchase = Inv_PurchaseManager.GetInv_PurchaseByID(PurchaseID);
lblPurchaseDate.Text = purchase.PurchseDate.ToString("dd-MMM-yyyy");
lblPurchaseID.Text = purchase.Inv_PurchaseID.ToString() + (purchase.RowStatusID == 3?"<b style='color:red;'>(Deleted)</b>":"");
lblPaymentType.Text = purchase.ExtraField3;
lblInvoiceNo.Text = purchase.InvoiceNo;
lblSupplierName.Text = purchase.SupplierName;
lblParticulars.Text = purchase.Particulars;
//Item Info
List <Inv_Item> items = new List <Inv_Item>();
items = Inv_ItemManager.GetAllInv_ItemsByPurchaseID(PurchaseID);
string htmlTable = @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
<tr id='tableHeader'>
<td style='border-left:0px;'>S/L</td>
<td>Product Code</td>
<td>Product Name</td>
<td>Quantity</td>
<td>Unit</td>
<td>Price</td>
<td>Amount</td>
</tr>";
int lastRawMaterialID = 0;
decimal Total = 0;
decimal Subtotal = 0;
decimal TotalAmount = 0;
decimal SubtotalAmount = 0;
int serialNo = 1;
foreach (Inv_Item item in items)
{
if (lastRawMaterialID != 0 && lastRawMaterialID != item.RawMaterialID)
{
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + Subtotal.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + SubtotalAmount.ToString("0,0.00") + @"</td>
</tr>";
Subtotal = 0;
SubtotalAmount = 0;
}
if (lastRawMaterialID != item.RawMaterialID)
{
lastRawMaterialID = item.RawMaterialID;
htmlTable += @"<tr>
<td colspan='7' style='padding-left:50px; border-top:1px solid black;border-bottom:1px solid black;font-weight:bold;'>
Item: " + item.RawMaterialName + @"
</td>
</tr>";
}
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
<td>" + item.ItemCode + @"</td>
<td>" + item.ItemName + @"</td>
<td style='text-align:right;'>" + item.PurchasedQuantity.ToString("0,0.00") + @"</td>
<td >" + item.QuantityUnitName + @"</td>
<td style='text-align:right;'>" + item.PricePerUnit.ToString("0,0.000000") + @"</td>
<td style='text-align:right;'>" + item.PurchasedQuantityPrice.ToString("0,0.00") + @"</td>
</tr>";
Subtotal += item.PurchasedQuantity;
SubtotalAmount += item.PurchasedQuantityPrice;
Total += item.PurchasedQuantity;
TotalAmount += item.PurchasedQuantityPrice;
}
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + Subtotal.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + SubtotalAmount.ToString("0,0.00") + @"</td>
</tr>";
htmlTable += @"<tr id='lastRow'>
<td> </td>
<td> </td>
<td>Grand Total</td>
<td>" + Total.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + TotalAmount.ToString("0,0.00") + @"</td>
</tr></table>";
lblItemList.Text = htmlTable;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ddlSuppier.SelectedValue == "0")
{
showAlartMessage("Please select the Supplier");
return;
}
List <Inv_Item> PurchasedItems = new List <Inv_Item>();
PurchasedItems = loadFromTheGrid();
if (PurchasedItems.Count == 0)
{
showAlartMessage("Please Add Items");
return;
}
int JournalMasterID = 0;
int pruchseID = 0;
if (txtOldPurchaseID.Text == "")
{
//Insert Purchse
Inv_Purchase inv_Purchase = new Inv_Purchase();
inv_Purchase.PurchaseName = "";
inv_Purchase.PurchseDate = DateTime.Parse(txtPurchseDate.Text);
inv_Purchase.SuppierID = Int32.Parse(ddlSuppier.SelectedValue);
inv_Purchase.InvoiceNo = txtInvoiceNo.Text;
inv_Purchase.Particulars = txtParticulars.Text;
inv_Purchase.IsPurchase = true;
inv_Purchase.WorkSatationID = 2;//Int32.Parse(ddlWorkSatation.SelectedValue);
inv_Purchase.ExtraField1 = rbtnlRawmaterialsType.SelectedValue;
inv_Purchase.ExtraField2 = "";
inv_Purchase.ExtraField3 = rbtnlPaymentType.SelectedValue;
inv_Purchase.ExtraField4 = "";
inv_Purchase.ExtraField5 = "";
inv_Purchase.AddedBy = getLogin().LoginID;
inv_Purchase.AddedDate = DateTime.Now;
inv_Purchase.UpdatedBy = getLogin().LoginID;
inv_Purchase.UpdatedDate = DateTime.Now;
inv_Purchase.RowStatusID = 1;
pruchseID = Inv_PurchaseManager.InsertInv_Purchase(inv_Purchase);
//Journal Entry
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = (rbtnlPaymentType.SelectedValue == "Cash" ? "2" : "3");//Journal Voucher
aCC_JournalMaster.ExtraField1 = ddlSuppier.SelectedItem.Text;
aCC_JournalMaster.ExtraField2 = "";
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = "Inventory Purchase-" + pruchseID.ToString();
aCC_JournalMaster.JournalDate = DateTime.Parse(txtPurchseDate.Text);
aCC_JournalMaster.AddedBy = getLogin().LoginID;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = getLogin().LoginID;
aCC_JournalMaster.UpdatedDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
//insert each Item
CommonManager.SQLExec("Update Inv_Purchase set ExtraField2='" + JournalMasterID.ToString() + "' where Inv_PurchaseID=" + pruchseID.ToString() + "; select 1");
}
else
{
string SQL = "select ACC_JournalMasterID from ACC_JournalMaster where Note='Inventory Purchase-" + txtOldPurchaseID.Text + "'";
try
{
JournalMasterID = int.Parse(CommonManager.SQLExec(SQL).Tables[0].Rows[0][0].ToString());
pruchseID = int.Parse(txtOldPurchaseID.Text);
}
catch (Exception ex)
{
showAlartMessage("Wrong Old PurchaseID");
return;
}
}
foreach (Inv_Item item in PurchasedItems)
{
item.PurchaseID = pruchseID;
item.UpdatedBy = JournalMasterID;//emporary we pass the journal master ID
item.ExtraField6 = rbtnlPaymentType.SelectedValue;
item.Inv_ItemID = Inv_ItemManager.InsertInv_Item(item);
}
PurchasedItems = new List <Inv_Item>();
showInv_ItemGrid(PurchasedItems);
hlnkPurchasePrint.NavigateUrl = "PurchasePrint.aspx?PurchaseID=" + pruchseID.ToString();
hlnkPurchasePrint.Visible = true;
}
