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