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