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(); }
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; } }
private bool Validation() { bool retValue = true; if (GetCustomerIdByName(txtCustomerName.Text.Trim()) == 0) { retValue = false; Message.Text = "Something went wrong! Customer ID not found. Please select customer from list while typing."; Message.IsSuccess = false; Message.Show = true; } if (retValue && string.IsNullOrEmpty(txtCustomerName.Text.Trim())) { retValue = false; Message.Text = "Please select customer name"; Message.IsSuccess = false; Message.Show = true; } if (retValue && string.IsNullOrEmpty(txtChallanNo.Text.Trim())) { retValue = false; Message.Text = "Please enter challan no."; Message.IsSuccess = false; Message.Show = true; } if (retValue && string.IsNullOrEmpty(txtOrderDate.Text.Trim())) { retValue = false; Message.Text = "Please enter order date."; Message.IsSuccess = false; Message.Show = true; } if (retValue && ddlChallanType.SelectedIndex == 0) { retValue = false; Message.Text = "Please select challan type."; Message.IsSuccess = false; Message.Show = true; } if (retValue && !(_ItemsList != null && _ItemsList.Rows.Count > 0)) { retValue = false; Message.Text = "Please add Items."; Message.IsSuccess = false; Message.Show = true; } if (Business.Common.Context.SelectedSaleAssets == null) { retValue = false; ClearMasterControls(); ClearItemControls(); Business.Common.Context.SelectedSaleAssets.Clear(); LoadItemList(); Message.Text = "Please select asset particulars."; Message.IsSuccess = false; Message.Show = true; } if (!Business.Common.Context.SelectedSaleAssets.AsEnumerable().Any()) { retValue = false; ClearMasterControls(); ClearItemControls(); Business.Common.Context.SelectedSaleAssets.Clear(); LoadItemList(); Message.Text = "Please select asset particulars."; Message.IsSuccess = false; Message.Show = true; } if (Business.Common.Context.SelectedSaleAssets.AsEnumerable().Where(p => p["Finalized"].ToString() == "False").Any()) { retValue = false; ClearMasterControls(); ClearItemControls(); Business.Common.Context.SelectedSaleAssets.Clear(); LoadItemList(); Message.Text = "Please click on Proceed button each time in Asset Selection page."; Message.IsSuccess = false; Message.Show = true; } DataTable dtSaleChallan = new Business.Sale.SaleChallan().Sale_Challan_GetAll(new Entity.Sale.SaleChallan() { ChallanNo = txtChallanNo.Text.Trim() }); if (dtSaleChallan.AsEnumerable().Any()) { retValue = false; Message.Text = "Challan no is already exists in the database."; Message.IsSuccess = false; Message.Show = true; } return(retValue); }
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; } }