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 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; }