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