private void Sale_GetAll() { Business.Sale.SaleChallan objSaleChallan = new Business.Sale.SaleChallan(); Entity.Sale.SaleChallan saleChallan = new Entity.Sale.SaleChallan(); saleChallan.CustomerName = txtCustomerName.Text.Trim(); saleChallan.ChallanNo = txtChallanNo.Text.Trim(); saleChallan.OrderNo = txtOrderNo.Text.Trim(); saleChallan.OrderFromDate = (string.IsNullOrEmpty(txtSaleFromDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtSaleFromDate.Text.Trim()); saleChallan.OrderToDate = (string.IsNullOrEmpty(txtSaleToDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtSaleToDate.Text.Trim()); saleChallan.ChallanTypeId = Convert.ToInt32(ddlChallanType.SelectedValue); if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL)) { saleChallan.CreatedBy = 0; } else { saleChallan.CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name); } if (ddlItem.SelectedIndex > 0) { saleChallan.ItemId = Convert.ToInt32(ddlItem.SelectedValue.Split('|')[0]); saleChallan.itemType = (ddlItem.SelectedValue.Split('|')[1] == ((int)ItemType.Product).ToString()) ? ItemType.Product : ItemType.Spare; } gvSale.DataSource = objSaleChallan.Sale_Challan_GetAll(saleChallan); gvSale.DataBind(); }
public static int Sale_ChallanDetails_Save(Entity.Sale.SaleChallan saleChallan) { int rowsAffacted = 0; foreach (Entity.Sale.SaleChallanDetails saleChallanDetails in saleChallan.SaleChallanDetailsCollection) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_Sale_ChallanDetails_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SaleChallanDetailsId", saleChallanDetails.SaleChallanDetailsId); cmd.Parameters.AddWithValue("@SaleChallanId", saleChallanDetails.SaleChallanId); cmd.Parameters.AddWithValue("@ItemId", saleChallanDetails.ItemId); cmd.Parameters.AddWithValue("@ItemType", saleChallanDetails.ItemType); cmd.Parameters.AddWithValue("@ItemQty", saleChallanDetails.ItemQty); cmd.Parameters.AddWithValue("@ItemRate", saleChallanDetails.ItemRate); cmd.Parameters.AddWithValue("@GST", saleChallanDetails.GST); cmd.Parameters.AddWithValue("@HSNCode", saleChallanDetails.HsnCode); cmd.Parameters.AddWithValue("@UOM", saleChallanDetails.Uom); cmd.Parameters.AddWithValue("@Error", string.Empty).Direction = ParameterDirection.InputOutput; if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted += cmd.ExecuteNonQuery(); con.Close(); } } } return(rowsAffacted); }
private int SaveSaleChallanDetails(Entity.Sale.SaleChallan saleChallan, Business.Sale.SaleChallan objSaleChallan, int saleChallanId) { foreach (DataRow drItem in _ItemsList.Rows) { saleChallan.SaleChallanDetailsCollection.Add( new Entity.Sale.SaleChallanDetails() { SaleChallanId = saleChallanId, 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, GST = (!string.IsNullOrEmpty(drItem["GST"].ToString())) ? Convert.ToDecimal(drItem["GST"].ToString()) : 0, HsnCode = drItem["HsnCode"].ToString(), Uom = 1 }); } int purchaseDetailsResponse = objSaleChallan.Sale_ChallanDetails_Save(saleChallan); return(purchaseDetailsResponse); }
protected void gvSale_RowCommand(object sender, GridViewCommandEventArgs e) { try { Business.Sale.SaleChallan objSaleChallan = new Business.Sale.SaleChallan(); Entity.Sale.SaleChallan saleChallan = new Entity.Sale.SaleChallan(); if (e.CommandName == "SaleDetails") { DataTable dt = objSaleChallan.SaleChallanDetails_GetBySaleChallanId(long.Parse(e.CommandArgument.ToString())); gvSaleDetails.DataSource = dt; gvSaleDetails.DataBind(); ModalPopupExtender1.Show(); } else if (e.CommandName == "D") { int response = objSaleChallan.Sale_Challan_Delete(int.Parse(e.CommandArgument.ToString())); if (response > 0) { Sale_GetAll(); Message.IsSuccess = true; Message.Text = "Deleted Successfully"; } else { Message.IsSuccess = false; Message.Text = "Data Dependency Exists, please contact system admin."; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public DataTable Sale_Challan_GetAll(Entity.Sale.SaleChallan saleChallan) { return(DataAccess.Sale.SaleChallan.Sale_Challan_GetAll(saleChallan)); }
public int Sale_ChallanDetails_Save(Entity.Sale.SaleChallan saleChallan) { return(DataAccess.Sale.SaleChallan.Sale_ChallanDetails_Save(saleChallan)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (Validation()) { Entity.Sale.SaleChallan saleChallan = new Entity.Sale.SaleChallan(); Business.Sale.SaleChallan objSaleChallan = new Business.Sale.SaleChallan(); Entity.Sale.SaleChallanDetails saleChallanDetails = new Entity.Sale.SaleChallanDetails(); Entity.Inventory.Inventory inventory = new Entity.Inventory.Inventory(); Business.Inventory.Inventory objInventory = new Business.Inventory.Inventory(); saleChallan.CustomerMasterId = GetCustomerIdByName(txtCustomerName.Text.Trim()); saleChallan.Note = txtNote.Text.Trim(); saleChallan.ChallanNo = (!string.IsNullOrEmpty(txtChallanNo.Text.Trim())) ? txtChallanNo.Text.Trim() : string.Empty; saleChallan.OrderNo = (!string.IsNullOrEmpty(txtOrderNo.Text.Trim())) ? txtOrderNo.Text.Trim() : string.Empty; saleChallan.OrderDate = (!string.IsNullOrEmpty(txtOrderDate.Text.Trim())) ? Convert.ToDateTime(txtOrderDate.Text.Trim()) : DateTime.MinValue; saleChallan.ChallanTypeId = Convert.ToInt32(ddlChallanType.SelectedValue); saleChallan.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name); int saleChallanId = objSaleChallan.SaleChallan_Save(saleChallan); int purchaseDetailsResponse = 0; if (saleChallanId > 0) { purchaseDetailsResponse = SaveSaleChallanDetails(saleChallan, objSaleChallan, saleChallanId); } else { throw new Exception("Something went wrong! Sale challan master value not inserted."); } if (purchaseDetailsResponse > 0) { using (DataTable dtInventory = new DataTable()) { inventory = PrepareInventoryDetails(saleChallanId, inventory, dtInventory); if (ddlChallanType.SelectedValue == "3")//Stock Transfer { StockLocation_Save(inventory); StockLocationTransaction_Save(inventory); Message.IsSuccess = true; Message.Text = "Stock transfer successful."; } else { int inventoryResponse = SaveInventoryDetails(inventory, objInventory); StockLocation_Delete(inventory); if (inventoryResponse > 0) { LoadItemList(); Message.IsSuccess = true; Message.Text = "Sale Order saved"; } else { Message.IsSuccess = false; Message.Text = "Inventory not saved"; } } ClearAllControls(); } } else { Message.IsSuccess = false; Message.Text = "Sale Order not saved"; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public static int SaleChallan_Save(Entity.Sale.SaleChallan saleChallan) { int purchaseId = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_Sale_Challan_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SaleChallanId", saleChallan.SaleChallanId).Direction = ParameterDirection.InputOutput; cmd.Parameters.AddWithValue("@CustomerMasterId", saleChallan.CustomerMasterId); if (saleChallan.Note != string.Empty) { cmd.Parameters.AddWithValue("@Note", saleChallan.Note); } else { cmd.Parameters.AddWithValue("@Note", DBNull.Value); } if (saleChallan.ChallanNo != string.Empty) { cmd.Parameters.AddWithValue("@ChallanNo", saleChallan.ChallanNo); } else { cmd.Parameters.AddWithValue("@ChallanNo", DBNull.Value); } if (saleChallan.OrderNo != string.Empty) { cmd.Parameters.AddWithValue("@OrderNo", saleChallan.OrderNo); } else { cmd.Parameters.AddWithValue("@OrderNo", DBNull.Value); } if (saleChallan.OrderDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@OrderDate", saleChallan.OrderDate); } else { cmd.Parameters.AddWithValue("@OrderDate", DBNull.Value); } cmd.Parameters.AddWithValue("@ChallanType", saleChallan.ChallanTypeId); cmd.Parameters.AddWithValue("@CreatedBy", saleChallan.CreatedBy); cmd.Parameters.AddWithValue("@Error", string.Empty).Direction = ParameterDirection.InputOutput; if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); purchaseId = Convert.ToInt32(cmd.Parameters["@SaleChallanId"].Value); con.Close(); if (!string.IsNullOrEmpty(cmd.Parameters["@Error"].Value.ToString())) { throw new Exception(cmd.Parameters["@Error"].Value.ToString()); } } } return(purchaseId); }
public static DataTable Sale_Challan_GetAll(Entity.Sale.SaleChallan saleChallan) { 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_Sale_Challan_GetAll"; if (!string.IsNullOrEmpty(saleChallan.CustomerName)) { cmd.Parameters.AddWithValue("@CustomerName", saleChallan.CustomerName); } else { cmd.Parameters.AddWithValue("@CustomerName", DBNull.Value); } if (!string.IsNullOrEmpty(saleChallan.ChallanNo)) { cmd.Parameters.AddWithValue("@ChallanNo", saleChallan.ChallanNo); } else { cmd.Parameters.AddWithValue("@ChallanNo", DBNull.Value); } if (!string.IsNullOrEmpty(saleChallan.OrderNo)) { cmd.Parameters.AddWithValue("@OrderNo", saleChallan.OrderNo); } else { cmd.Parameters.AddWithValue("@OrderNo", DBNull.Value); } if (saleChallan.OrderFromDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@OrderFromDate", saleChallan.OrderFromDate); } else { cmd.Parameters.AddWithValue("@OrderFromDate", DBNull.Value); } if (saleChallan.OrderToDate != DateTime.MinValue) { cmd.Parameters.AddWithValue("@OrderToDate", saleChallan.OrderToDate); } else { cmd.Parameters.AddWithValue("@OrderToDate", DBNull.Value); } if (saleChallan.CreatedBy > 0) { cmd.Parameters.AddWithValue("@CreatedBy", saleChallan.CreatedBy); } else { cmd.Parameters.AddWithValue("@CreatedBy", DBNull.Value); } if (saleChallan.ItemId > 0) { cmd.Parameters.AddWithValue("@ItemId", saleChallan.ItemId); cmd.Parameters.AddWithValue("@ItemType", (int)saleChallan.itemType); } else { cmd.Parameters.AddWithValue("@ItemId", DBNull.Value); cmd.Parameters.AddWithValue("@ItemType", DBNull.Value); } if (saleChallan.ChallanTypeId > 0) { cmd.Parameters.AddWithValue("@ChallanTypeId", saleChallan.ChallanTypeId); } else { cmd.Parameters.AddWithValue("@ChallanTypeId", DBNull.Value); } if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }