private void Purchase_GetAll() { Business.Purchase.Purchase objPurchase = new Business.Purchase.Purchase(); Entity.Purchase.Purchase purchase = new Entity.Purchase.Purchase(); purchase.PurchaseOrderNo = txtPurchaseOrderNo.Text.Trim(); purchase.VendorId = Convert.ToInt32(ddlVendor.SelectedValue); purchase.InvoiceNo = txtInvoiceNo.Text.Trim(); purchase.InvoiceFromDate = (string.IsNullOrEmpty(txtInvoiceFromDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtInvoiceFromDate.Text.Trim()); purchase.InvoiceToDate = (string.IsNullOrEmpty(txtInvoiceToDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtInvoiceToDate.Text.Trim()); purchase.PurchaseFromDate = (string.IsNullOrEmpty(txtPurchaseFromDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtPurchaseFromDate.Text.Trim()); purchase.PurchaseToDate = (string.IsNullOrEmpty(txtPurchaseToDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtPurchaseToDate.Text.Trim()); if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL)) { purchase.CreatedBy = 0; } else { purchase.CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name); } if (ddlItem.SelectedIndex > 0) { purchase.ItemId = Convert.ToInt32(ddlItem.SelectedValue.Split('|')[0]); purchase.itemType = (ddlItem.SelectedValue.Split('|')[1] == ((int)ItemType.Product).ToString()) ? ItemType.Product : ItemType.Spare; } gvPurchase.DataSource = objPurchase.Purchase_GetAll(purchase); gvPurchase.DataBind(); }
public static int Purchase_Save(Entity.Purchase.Purchase purchase) { int purchaseId = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_Purchase_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PurchaseId", purchase.PurchaseId).Direction = ParameterDirection.InputOutput; if (purchase.PurchaseOrderNo != string.Empty) { cmd.Parameters.AddWithValue("@PurchaseOrderNo", purchase.PurchaseOrderNo); } else { cmd.Parameters.AddWithValue("@PurchaseOrderNo", DBNull.Value); } cmd.Parameters.AddWithValue("@VendorId", purchase.VendorId); if (purchase.InvoiceNo != string.Empty) { cmd.Parameters.AddWithValue("@InvoiceNo", purchase.InvoiceNo); } else { cmd.Parameters.AddWithValue("@InvoiceNo", DBNull.Value); } if (purchase.InvoiceDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@InvoiceDate", purchase.InvoiceDate); } else { cmd.Parameters.AddWithValue("@InvoiceDate", DBNull.Value); } cmd.Parameters.AddWithValue("@PurchaseDate", purchase.PurchaseDate); cmd.Parameters.AddWithValue("@BillAmount", purchase.BillAmount); cmd.Parameters.AddWithValue("@PaymentAmount", purchase.PaymentAmount); cmd.Parameters.AddWithValue("@CreatedBy", purchase.CreatedBy); cmd.Parameters.AddWithValue("@Error", string.Empty).Direction = ParameterDirection.InputOutput; if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); purchaseId = Convert.ToInt32(cmd.Parameters["@PurchaseId"].Value); con.Close(); } } return(purchaseId); }
protected void gvPurchase_RowCommand(object sender, GridViewCommandEventArgs e) { try { Business.Purchase.Purchase objPurchase = new Business.Purchase.Purchase(); Entity.Purchase.Purchase purchase = new Entity.Purchase.Purchase(); if (e.CommandName == "PurchaseDetails") { DataTable dt = objPurchase.PurchaseDetails_GetByPurchaseId(int.Parse(e.CommandArgument.ToString())); gvPurchaseDetails.DataSource = dt; gvPurchaseDetails.DataBind(); ModalPopupExtender1.Show(); } } catch (Exception ex) { ex.WriteException(); } }
public static int PurchaseDetails_Save(Entity.Purchase.Purchase purchase) { int rowsAffacted = 0; foreach (Entity.Purchase.PurchaseDetails purchasedetails in purchase.PurchaseDetailsCollection) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_PurchaseDetails_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PurchaseDetailsId", purchasedetails.PurchaseDetailsId); cmd.Parameters.AddWithValue("@PurchaseId", purchasedetails.PurchaseId); cmd.Parameters.AddWithValue("@ItemId", purchasedetails.ItemId); cmd.Parameters.AddWithValue("@ItemType", purchasedetails.ItemType); cmd.Parameters.AddWithValue("@ItemQty", purchasedetails.ItemQty); cmd.Parameters.AddWithValue("@ItemRate", purchasedetails.ItemRate); cmd.Parameters.AddWithValue("@GST", purchasedetails.GST); cmd.Parameters.AddWithValue("@Discount", purchasedetails.Discount); cmd.Parameters.AddWithValue("@HSNCode", purchasedetails.HsnCode); cmd.Parameters.AddWithValue("@UOM", purchasedetails.Uom); cmd.Parameters.AddWithValue("@EmployeeId", purchase.CreatedBy); cmd.Parameters.AddWithValue("@Error", string.Empty).Direction = ParameterDirection.InputOutput; if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted += cmd.ExecuteNonQuery(); con.Close(); } } } return(rowsAffacted); }
public DataTable Purchase_GetAll(Entity.Purchase.Purchase purchase) { return(DataAccess.Purchase.Purchase.Purchase_GetAll(purchase)); }
public int PurchaseDetails_Save(Entity.Purchase.Purchase purchase) { return(DataAccess.Purchase.Purchase.PurchaseDetails_Save(purchase)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (Validation()) { Entity.Purchase.Purchase purchase = new Entity.Purchase.Purchase(); Business.Purchase.Purchase objPurchase = new Business.Purchase.Purchase(); Entity.Purchase.PurchaseDetails purchaseDetails = new Entity.Purchase.PurchaseDetails(); Entity.Inventory.Inventory inventory = new Entity.Inventory.Inventory(); Business.Inventory.Inventory objInventory = new Business.Inventory.Inventory(); purchase.PurchaseOrderNo = (!string.IsNullOrEmpty(txtPurchaseOrderNo.Text.Trim())) ? txtPurchaseOrderNo.Text.Trim() : string.Empty; purchase.PurchaseDate = Convert.ToDateTime(txtPurchaseDate.Text.Trim()); purchase.VendorId = Convert.ToInt32(ddlVendor.SelectedValue); purchase.InvoiceNo = (!string.IsNullOrEmpty(txtInvoiceNo.Text.Trim())) ? txtInvoiceNo.Text.Trim() : string.Empty; purchase.InvoiceDate = (!string.IsNullOrEmpty(txtInvoiceDate.Text.Trim())) ? Convert.ToDateTime(txtInvoiceDate.Text.Trim()) : DateTime.MinValue; purchase.BillAmount = (!string.IsNullOrEmpty(txtBillAmount.Text.Trim())) ? Convert.ToDecimal(txtBillAmount.Text.Trim()) : 0; purchase.PaymentAmount = (!string.IsNullOrEmpty(txtPaymentAmount.Text.Trim())) ? Convert.ToDecimal(txtPaymentAmount.Text.Trim()) : 0; int purchaseId = objPurchase.Purchase_Save(purchase); foreach (DataRow drItem in _ItemsList.Rows) { purchase.PurchaseDetailsCollection.Add( new Entity.Purchase.PurchaseDetails() { PurchaseId = purchaseId, ItemId = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[0]), ItemType = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[1]), ItemQty = (!string.IsNullOrEmpty(drItem["Quantity"].ToString())) ? Convert.ToDecimal(drItem["Quantity"].ToString()) : 0, ItemRate = (!string.IsNullOrEmpty(drItem["Rate"].ToString())) ? Convert.ToDecimal(drItem["Rate"].ToString()) : 0, Discount = (!string.IsNullOrEmpty(drItem["Discount"].ToString())) ? Convert.ToDecimal(drItem["Discount"].ToString()) : 0, GST = (!string.IsNullOrEmpty(drItem["GST"].ToString())) ? Convert.ToDecimal(drItem["GST"].ToString()) : 0, HsnCode = drItem["HsnCode"].ToString() }); } int purchaseDetailsResponse = objPurchase.PurchaseDetails_Save(purchase); if (purchaseDetailsResponse > 0) { using (DataTable dtInventory = new DataTable()) { dtInventory.Columns.Add("AssetId"); dtInventory.Columns.Add("ItemId"); dtInventory.Columns.Add("ItemType"); dtInventory.Columns.Add("AssetLocationId"); dtInventory.Columns.Add("CustomerId"); dtInventory.Columns.Add("SaleChallanId"); dtInventory.Columns.Add("EmployeeId"); dtInventory.Columns.Add("StoreId"); foreach (DataRow drItem in _ItemsList.Rows) { for (int qty = 1; qty <= Convert.ToInt32(drItem["Quantity"]); qty++) { DataRow drInventoryItem = dtInventory.NewRow(); drInventoryItem["AssetId"] = Guid.NewGuid().ToString().ToUpper(); drInventoryItem["ItemId"] = drItem["ItemIdType"].ToString().Split('|')[0]; drInventoryItem["ItemType"] = drItem["ItemIdType"].ToString().Split('|')[1]; drInventoryItem["AssetLocationId"] = (int)AssetLocation.Store; //Stock In drInventoryItem["CustomerId"] = ""; drInventoryItem["SaleChallanId"] = ""; drInventoryItem["EmployeeId"] = Convert.ToInt32(HttpContext.Current.User.Identity.Name); drInventoryItem["StoreId"] = Convert.ToInt32(ddlStore.SelectedValue); dtInventory.Rows.Add(drInventoryItem); dtInventory.AcceptChanges(); } } inventory.InventoryDetails = dtInventory; int inventoryResponse = objInventory.Inventory_Save(inventory); if (inventoryResponse > 0) { GlobalCache.RemoveAll(); ClearMasterControls(); ClearItemControls(); LoadItemList(); Message.IsSuccess = true; Message.Text = "Purchase Order saved"; } else { Message.IsSuccess = false; Message.Text = "Inventory not saved"; } } } else { Message.IsSuccess = false; Message.Text = "Purchase Order not saved"; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public static DataTable Purchase_GetAll(Entity.Purchase.Purchase purchase) { using (DataTable dt = new DataTable()) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Purchase_GetAll"; if (!string.IsNullOrEmpty(purchase.PurchaseOrderNo)) { cmd.Parameters.AddWithValue("@PurchaseOrderNo", purchase.PurchaseOrderNo); } else { cmd.Parameters.AddWithValue("@PurchaseOrderNo", DBNull.Value); } if (purchase.VendorId > 0) { cmd.Parameters.AddWithValue("@VendorId", purchase.VendorId); } else { cmd.Parameters.AddWithValue("@VendorId", DBNull.Value); } if (!string.IsNullOrEmpty(purchase.InvoiceNo)) { cmd.Parameters.AddWithValue("@InvoiceNo", purchase.InvoiceNo); } else { cmd.Parameters.AddWithValue("@InvoiceNo", DBNull.Value); } if (purchase.InvoiceFromDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@InvoiceFromDate", purchase.InvoiceFromDate); } else { cmd.Parameters.AddWithValue("@InvoiceFromDate", DBNull.Value); } if (purchase.InvoiceToDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@InvoiceToDate", purchase.InvoiceToDate); } else { cmd.Parameters.AddWithValue("@InvoiceToDate", DBNull.Value); } if (purchase.PurchaseFromDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@FromDate", purchase.PurchaseFromDate); } else { cmd.Parameters.AddWithValue("@FromDate", DBNull.Value); } if (purchase.PurchaseToDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@ToDate", purchase.PurchaseToDate); } else { cmd.Parameters.AddWithValue("@ToDate", DBNull.Value); } if (purchase.CreatedBy > 0) { cmd.Parameters.AddWithValue("@CreatedBy", purchase.CreatedBy); } else { cmd.Parameters.AddWithValue("@CreatedBy", DBNull.Value); } if (purchase.ItemId > 0) { cmd.Parameters.AddWithValue("@ItemId", purchase.ItemId); cmd.Parameters.AddWithValue("@ItemType", (int)purchase.itemType); } else { cmd.Parameters.AddWithValue("@ItemId", DBNull.Value); cmd.Parameters.AddWithValue("@ItemType", DBNull.Value); } if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }