public bool UpdateInv_Purchase(Inv_Purchase inv_Purchase)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Purchase", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_PurchaseID", SqlDbType.Int).Value = inv_Purchase.Inv_PurchaseID;
cmd.Parameters.Add("@PurchaseName", SqlDbType.NVarChar).Value = inv_Purchase.PurchaseName;
cmd.Parameters.Add("@PurchseDate", SqlDbType.DateTime).Value = inv_Purchase.PurchseDate;
cmd.Parameters.Add("@SuppierID", SqlDbType.Int).Value = inv_Purchase.SuppierID;
cmd.Parameters.Add("@InvoiceNo", SqlDbType.NVarChar).Value = inv_Purchase.InvoiceNo;
cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value = inv_Purchase.Particulars;
cmd.Parameters.Add("@IsPurchase", SqlDbType.Bit).Value = inv_Purchase.IsPurchase;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_Purchase.WorkSatationID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Purchase.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Purchase.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Purchase.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Purchase.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Purchase.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
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 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");
}
public static Inv_Purchase GetInv_PurchaseByID(int id)
{
Inv_Purchase inv_Purchase = new Inv_Purchase();
SqlInv_PurchaseProvider sqlInv_PurchaseProvider = new SqlInv_PurchaseProvider();
inv_Purchase = sqlInv_PurchaseProvider.GetInv_PurchaseByID(id);
return inv_Purchase;
}
public static Inv_Purchase GetInv_PurchaseByID(int id)
{
Inv_Purchase inv_Purchase = new Inv_Purchase();
SqlInv_PurchaseProvider sqlInv_PurchaseProvider = new SqlInv_PurchaseProvider();
inv_Purchase = sqlInv_PurchaseProvider.GetInv_PurchaseByID(id);
return(inv_Purchase);
}
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();
}
public Inv_Purchase GetInv_PurchaseFromReader(IDataReader reader)
{
try
{
Inv_Purchase inv_Purchase = new Inv_Purchase
(
(int)reader["Inv_PurchaseID"],
reader["PurchaseName"].ToString(),
(DateTime)reader["PurchseDate"],
(int)reader["SuppierID"],
reader["InvoiceNo"].ToString(),
reader["Particulars"].ToString(),
(bool)reader["IsPurchase"],
(int)reader["WorkSatationID"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
try
{ inv_Purchase.SupplierName = reader["SupplierName"].ToString(); }
catch (Exception ex) { }
return(inv_Purchase);
}
catch (Exception ex)
{
return(null);
}
}
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");
}
public static bool UpdateInv_Purchase(Inv_Purchase inv_Purchase)
{
SqlInv_PurchaseProvider sqlInv_PurchaseProvider = new SqlInv_PurchaseProvider();
return(sqlInv_PurchaseProvider.UpdateInv_Purchase(inv_Purchase));
}
public static int InsertInv_Purchase(Inv_Purchase inv_Purchase)
{
SqlInv_PurchaseProvider sqlInv_PurchaseProvider = new SqlInv_PurchaseProvider();
return(sqlInv_PurchaseProvider.InsertInv_Purchase(inv_Purchase));
}
public Inv_Purchase GetInv_PurchaseFromReader(IDataReader reader)
{
try
{
Inv_Purchase inv_Purchase = new Inv_Purchase
(
(int)reader["Inv_PurchaseID"],
reader["PurchaseName"].ToString(),
(DateTime)reader["PurchseDate"],
(int)reader["SuppierID"],
reader["InvoiceNo"].ToString(),
reader["Particulars"].ToString(),
(bool)reader["IsPurchase"],
(int)reader["WorkSatationID"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
try
{ inv_Purchase.SupplierName = reader["SupplierName"].ToString(); }
catch (Exception ex) { }
return inv_Purchase;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateInv_Purchase(Inv_Purchase inv_Purchase)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Purchase", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_PurchaseID", SqlDbType.Int).Value = inv_Purchase.Inv_PurchaseID;
cmd.Parameters.Add("@PurchaseName", SqlDbType.NVarChar).Value = inv_Purchase.PurchaseName;
cmd.Parameters.Add("@PurchseDate", SqlDbType.DateTime).Value = inv_Purchase.PurchseDate;
cmd.Parameters.Add("@SuppierID", SqlDbType.Int).Value = inv_Purchase.SuppierID;
cmd.Parameters.Add("@InvoiceNo", SqlDbType.NVarChar).Value = inv_Purchase.InvoiceNo;
cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value = inv_Purchase.Particulars;
cmd.Parameters.Add("@IsPurchase", SqlDbType.Bit).Value = inv_Purchase.IsPurchase;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_Purchase.WorkSatationID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Purchase.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Purchase.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Purchase.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Purchase.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Purchase.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Purchase.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public static int InsertInv_Purchase(Inv_Purchase inv_Purchase)
{
SqlInv_PurchaseProvider sqlInv_PurchaseProvider = new SqlInv_PurchaseProvider();
return sqlInv_PurchaseProvider.InsertInv_Purchase(inv_Purchase);
}
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 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;
}
public static bool UpdateInv_Purchase(Inv_Purchase inv_Purchase)
{
SqlInv_PurchaseProvider sqlInv_PurchaseProvider = new SqlInv_PurchaseProvider();
return sqlInv_PurchaseProvider.UpdateInv_Purchase(inv_Purchase);
}
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;
}
