private void addConfiguration()
{
if (txtConfigPerProductRequiredQuantity.Text != "0")
{
Inv_Item itemSelected = Inv_ItemManager.GetInv_ItemByID(int.Parse(ddlItem.SelectedValue));
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_ProductionConfiguration.QualityValue = itemSelected.QualityValue;
inv_ProductionConfiguration.QualityUnitID = itemSelected.QualityUnitID;
inv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtConfigPerProductRequiredQuantity.Text);
inv_ProductionConfiguration.QuantityUnitID = itemSelected.QuantityUnitID;
inv_ProductionConfiguration.RawMaterialID = itemSelected.RawMaterialID;
inv_ProductionConfiguration.ExtraField1 = "";
inv_ProductionConfiguration.ExtraField2 = "";
inv_ProductionConfiguration.ExtraField3 = "";
inv_ProductionConfiguration.ExtraField4 = "";
inv_ProductionConfiguration.ExtraField5 = "";
inv_ProductionConfiguration.AddedBy = getLogin().LoginID;
inv_ProductionConfiguration.AddedDate = DateTime.Now;
inv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
inv_ProductionConfiguration.UpdatedDate = DateTime.Now;
inv_ProductionConfiguration.RowStatusID = 1;
int resutl = Inv_ProductionConfigurationManager.InsertInv_ProductionConfiguration(inv_ProductionConfiguration);
trConfigPerProductRequiredQuantity.Visible = false;
}
}
public static Inv_Item GetInv_ItemByID(int id)
{
Inv_Item inv_Item = new Inv_Item();
SqlInv_ItemProvider sqlInv_ItemProvider = new SqlInv_ItemProvider();
inv_Item = sqlInv_ItemProvider.GetInv_ItemByID(id);
return(inv_Item);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_Item inv_Item = new Inv_Item();
inv_Item = Inv_ItemManager.GetInv_ItemByID(Int32.Parse(Request.QueryString["inv_ItemID"]));
Inv_Item tempInv_Item = new Inv_Item();
tempInv_Item.Inv_ItemID = inv_Item.Inv_ItemID;
tempInv_Item.ItemName = txtItemName.Text;
tempInv_Item.PurchaseID = Int32.Parse(ddlPurchase.SelectedValue);
tempInv_Item.ItemCode = txtItemCode.Text;
tempInv_Item.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
tempInv_Item.StoreID = Int32.Parse(ddlStore.SelectedValue);
tempInv_Item.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
tempInv_Item.QualityValue = Decimal.Parse(txtQualityValue.Text);
tempInv_Item.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
tempInv_Item.PricePerUnit = Decimal.Parse(txtPricePerUnit.Text);
tempInv_Item.PurchasedQuantity = Decimal.Parse(txtPurchasedQuantity.Text);
tempInv_Item.IssueReturedQuantity = Decimal.Parse(txtIssueReturedQuantity.Text);
tempInv_Item.UtilizedQuantity = Decimal.Parse(txtUtilizedQuantity.Text);
tempInv_Item.LostQuantity = Decimal.Parse(txtLostQuantity.Text);
tempInv_Item.ExtraFieldQuantity1 = Decimal.Parse(txtExtraFieldQuantity1.Text);
tempInv_Item.ExtraFieldQuantity2 = Decimal.Parse(txtExtraFieldQuantity2.Text);
tempInv_Item.ExtraFieldQuantity3 = Decimal.Parse(txtExtraFieldQuantity3.Text);
tempInv_Item.ExtraFieldQuantity4 = Decimal.Parse(txtExtraFieldQuantity4.Text);
tempInv_Item.ExtraFieldQuantity5 = Decimal.Parse(txtExtraFieldQuantity5.Text);
tempInv_Item.ExtraField1 = txtExtraField1.Text;
tempInv_Item.ExtraField2 = txtExtraField2.Text;
tempInv_Item.ExtraField3 = txtExtraField3.Text;
tempInv_Item.ExtraField4 = txtExtraField4.Text;
tempInv_Item.ExtraField5 = txtExtraField5.Text;
tempInv_Item.ExtraField6 = txtExtraField6.Text;
tempInv_Item.ExtraField7 = txtExtraField7.Text;
tempInv_Item.ExtraField8 = txtExtraField8.Text;
tempInv_Item.ExtraField9 = txtExtraField9.Text;
tempInv_Item.ExtraField10 = txtExtraField10.Text;
tempInv_Item.AddedBy = getLogin().LoginID;
tempInv_Item.AddedDate = DateTime.Now;
tempInv_Item.UpdatedBy = getLogin().LoginID;
tempInv_Item.UpdatedDate = DateTime.Now;
tempInv_Item.RowStatusID = 1;
bool result = Inv_ItemManager.UpdateInv_Item(tempInv_Item);
Response.Redirect("ItemHistory.aspx?ItemID=" + inv_Item.Inv_ItemID.ToString());
}
public bool UpdateInv_Item(Inv_Item inv_Item)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Item", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_ItemID", SqlDbType.Int).Value = inv_Item.Inv_ItemID;
cmd.Parameters.Add("@ItemName", SqlDbType.NVarChar).Value = inv_Item.ItemName;
cmd.Parameters.Add("@PurchaseID", SqlDbType.Int).Value = inv_Item.PurchaseID;
cmd.Parameters.Add("@ItemCode", SqlDbType.NChar).Value = inv_Item.ItemCode;
cmd.Parameters.Add("@RawMaterialID", SqlDbType.Int).Value = inv_Item.RawMaterialID;
cmd.Parameters.Add("@StoreID", SqlDbType.Int).Value = inv_Item.StoreID;
cmd.Parameters.Add("@QualityUnitID", SqlDbType.Int).Value = inv_Item.QualityUnitID;
cmd.Parameters.Add("@QualityValue", SqlDbType.Decimal).Value = inv_Item.QualityValue;
cmd.Parameters.Add("@QuantityUnitID", SqlDbType.Int).Value = inv_Item.QuantityUnitID;
cmd.Parameters.Add("@PricePerUnit", SqlDbType.Decimal).Value = inv_Item.PricePerUnit;
cmd.Parameters.Add("@PurchasedQuantity", SqlDbType.Decimal).Value = inv_Item.PurchasedQuantity;
cmd.Parameters.Add("@IssueReturedQuantity", SqlDbType.Decimal).Value = inv_Item.IssueReturedQuantity;
cmd.Parameters.Add("@UtilizedQuantity", SqlDbType.Decimal).Value = inv_Item.UtilizedQuantity;
cmd.Parameters.Add("@LostQuantity", SqlDbType.Decimal).Value = inv_Item.LostQuantity;
cmd.Parameters.Add("@ExtraFieldQuantity1", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity1;
cmd.Parameters.Add("@ExtraFieldQuantity2", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity2;
cmd.Parameters.Add("@ExtraFieldQuantity3", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity3;
cmd.Parameters.Add("@ExtraFieldQuantity4", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity4;
cmd.Parameters.Add("@ExtraFieldQuantity5", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity5;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_Item.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Item.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Item.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Item.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Item.ExtraField5;
cmd.Parameters.Add("@ExtraField6", SqlDbType.NVarChar).Value = inv_Item.ExtraField6;
cmd.Parameters.Add("@ExtraField7", SqlDbType.NVarChar).Value = inv_Item.ExtraField7;
cmd.Parameters.Add("@ExtraField8", SqlDbType.NVarChar).Value = inv_Item.ExtraField8;
cmd.Parameters.Add("@ExtraField9", SqlDbType.NVarChar).Value = inv_Item.ExtraField9;
cmd.Parameters.Add("@ExtraField10", SqlDbType.NVarChar).Value = inv_Item.ExtraField10;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Item.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Item.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Item.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Item.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Item.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_Item inv_Item = new Inv_Item();
inv_Item.ItemName = txtItemName.Text;
inv_Item.PurchaseID = Int32.Parse(ddlPurchase.SelectedValue);
inv_Item.ItemCode = txtItemCode.Text;
inv_Item.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
inv_Item.StoreID = Int32.Parse(ddlStore.SelectedValue);
inv_Item.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
inv_Item.QualityValue = Decimal.Parse(txtQualityValue.Text);
inv_Item.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
inv_Item.PricePerUnit = Decimal.Parse(txtPricePerUnit.Text);
inv_Item.PurchasedQuantity = Decimal.Parse(txtPurchasedQuantity.Text);
inv_Item.IssueReturedQuantity = Decimal.Parse(txtIssueReturedQuantity.Text);
inv_Item.UtilizedQuantity = Decimal.Parse(txtUtilizedQuantity.Text);
inv_Item.LostQuantity = Decimal.Parse(txtLostQuantity.Text);
inv_Item.ExtraFieldQuantity1 = Decimal.Parse(txtExtraFieldQuantity1.Text);
inv_Item.ExtraFieldQuantity2 = Decimal.Parse(txtExtraFieldQuantity2.Text);
inv_Item.ExtraFieldQuantity3 = Decimal.Parse(txtExtraFieldQuantity3.Text);
inv_Item.ExtraFieldQuantity4 = Decimal.Parse(txtExtraFieldQuantity4.Text);
inv_Item.ExtraFieldQuantity5 = Decimal.Parse(txtExtraFieldQuantity5.Text);
inv_Item.ExtraField1 = txtExtraField1.Text;
inv_Item.ExtraField2 = txtExtraField2.Text;
inv_Item.ExtraField3 = txtExtraField3.Text;
inv_Item.ExtraField4 = txtExtraField4.Text;
inv_Item.ExtraField5 = txtExtraField5.Text;
inv_Item.ExtraField6 = txtExtraField6.Text;
inv_Item.ExtraField7 = txtExtraField7.Text;
inv_Item.ExtraField8 = txtExtraField8.Text;
inv_Item.ExtraField9 = txtExtraField9.Text;
inv_Item.ExtraField10 = txtExtraField10.Text;
inv_Item.AddedBy = getLogin().LoginID;
inv_Item.AddedDate = DateTime.Now;
inv_Item.UpdatedBy = getLogin().LoginID;
inv_Item.UpdatedDate = DateTime.Now;
inv_Item.RowStatusID = 1;
int resutl = Inv_ItemManager.InsertInv_Item(inv_Item);
Response.Redirect("AdminInv_ItemDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_Item inv_Item = new Inv_Item();
inv_Item.ItemName = txtItemName.Text;
inv_Item.PurchaseID = Int32.Parse(ddlPurchase.SelectedValue);
inv_Item.ItemCode = txtItemCode.Text;
inv_Item.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
inv_Item.StoreID = Int32.Parse(ddlStore.SelectedValue);
inv_Item.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
inv_Item.QualityValue = Decimal.Parse(txtQualityValue.Text);
inv_Item.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
inv_Item.PricePerUnit = Decimal.Parse(txtPricePerUnit.Text);
inv_Item.PurchasedQuantity = Decimal.Parse(txtPurchasedQuantity.Text);
inv_Item.IssueReturedQuantity = Decimal.Parse(txtIssueReturedQuantity.Text);
inv_Item.UtilizedQuantity = Decimal.Parse(txtUtilizedQuantity.Text);
inv_Item.LostQuantity = Decimal.Parse(txtLostQuantity.Text);
inv_Item.ExtraFieldQuantity1 = Decimal.Parse(txtExtraFieldQuantity1.Text);
inv_Item.ExtraFieldQuantity2 = Decimal.Parse(txtExtraFieldQuantity2.Text);
inv_Item.ExtraFieldQuantity3 = Decimal.Parse(txtExtraFieldQuantity3.Text);
inv_Item.ExtraFieldQuantity4 = Decimal.Parse(txtExtraFieldQuantity4.Text);
inv_Item.ExtraFieldQuantity5 = Decimal.Parse(txtExtraFieldQuantity5.Text);
inv_Item.ExtraField1 = txtExtraField1.Text;
inv_Item.ExtraField2 = txtExtraField2.Text;
inv_Item.ExtraField3 = txtExtraField3.Text;
inv_Item.ExtraField4 = txtExtraField4.Text;
inv_Item.ExtraField5 = txtExtraField5.Text;
inv_Item.ExtraField6 = txtExtraField6.Text;
inv_Item.ExtraField7 = txtExtraField7.Text;
inv_Item.ExtraField8 = txtExtraField8.Text;
inv_Item.ExtraField9 = txtExtraField9.Text;
inv_Item.ExtraField10 = txtExtraField10.Text;
inv_Item.AddedBy =getLogin().LoginID;
inv_Item.AddedDate = DateTime.Now;
inv_Item.UpdatedBy = getLogin().LoginID;
inv_Item.UpdatedDate = DateTime.Now;
inv_Item.RowStatusID = 1;
int resutl = Inv_ItemManager.InsertInv_Item(inv_Item);
Response.Redirect("AdminInv_ItemDisplay.aspx");
}
private void showInv_ItemData()
{
Inv_Item inv_Item = new Inv_Item();
inv_Item = Inv_ItemManager.GetInv_ItemByID(Int32.Parse(Request.QueryString["inv_ItemID"]));
txtItemName.Text = inv_Item.ItemName;
ddlPurchase.SelectedValue = inv_Item.PurchaseID.ToString();
txtItemCode.Text = inv_Item.ItemCode;
ddlRawMaterial.SelectedValue = inv_Item.RawMaterialID.ToString();
ddlStore.SelectedValue = inv_Item.StoreID.ToString();
ddlQualityUnit.SelectedValue = inv_Item.QualityUnitID.ToString();
txtQualityValue.Text = inv_Item.QualityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_Item.QuantityUnitID.ToString();
txtPricePerUnit.Text = inv_Item.PricePerUnit.ToString();
txtPurchasedQuantity.Text = inv_Item.PurchasedQuantity.ToString();
txtIssueReturedQuantity.Text = inv_Item.IssueReturedQuantity.ToString();
txtUtilizedQuantity.Text = inv_Item.UtilizedQuantity.ToString();
txtLostQuantity.Text = inv_Item.LostQuantity.ToString();
txtExtraFieldQuantity1.Text = inv_Item.ExtraFieldQuantity1.ToString();
txtExtraFieldQuantity2.Text = inv_Item.ExtraFieldQuantity2.ToString();
txtExtraFieldQuantity3.Text = inv_Item.ExtraFieldQuantity3.ToString();
txtExtraFieldQuantity4.Text = inv_Item.ExtraFieldQuantity4.ToString();
txtExtraFieldQuantity5.Text = inv_Item.ExtraFieldQuantity5.ToString();
txtExtraField1.Text = inv_Item.ExtraField1;
txtExtraField2.Text = inv_Item.ExtraField2;
txtExtraField3.Text = inv_Item.ExtraField3;
txtExtraField4.Text = inv_Item.ExtraField4;
txtExtraField5.Text = inv_Item.ExtraField5;
txtExtraField6.Text = inv_Item.ExtraField6;
txtExtraField7.Text = inv_Item.ExtraField7;
txtExtraField8.Text = inv_Item.ExtraField8;
txtExtraField9.Text = inv_Item.ExtraField9;
txtExtraField10.Text = inv_Item.ExtraField10;
txtAddedBy.Text = inv_Item.AddedBy.ToString();
txtUpdatedBy.Text = inv_Item.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_Item.UpdatedDate.ToString("yyyy-MM-dd hh:mm tt");
ddlRowStatus.SelectedValue = inv_Item.RowStatusID.ToString();
}
private void showInv_ItemData()
{
Inv_Item inv_Item = new Inv_Item();
inv_Item = Inv_ItemManager.GetInv_ItemByID(Int32.Parse(Request.QueryString["inv_ItemID"]));
txtItemName.Text = inv_Item.ItemName;
ddlPurchase.SelectedValue = inv_Item.PurchaseID.ToString();
txtItemCode.Text = inv_Item.ItemCode;
ddlRawMaterial.SelectedValue = inv_Item.RawMaterialID.ToString();
ddlStore.SelectedValue = inv_Item.StoreID.ToString();
ddlQualityUnit.SelectedValue = inv_Item.QualityUnitID.ToString();
txtQualityValue.Text = inv_Item.QualityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_Item.QuantityUnitID.ToString();
txtPricePerUnit.Text = inv_Item.PricePerUnit.ToString();
txtPurchasedQuantity.Text = inv_Item.PurchasedQuantity.ToString();
txtIssueReturedQuantity.Text = inv_Item.IssueReturedQuantity.ToString();
txtUtilizedQuantity.Text = inv_Item.UtilizedQuantity.ToString();
txtLostQuantity.Text = inv_Item.LostQuantity.ToString();
txtExtraFieldQuantity1.Text = inv_Item.ExtraFieldQuantity1.ToString();
txtExtraFieldQuantity2.Text = inv_Item.ExtraFieldQuantity2.ToString();
txtExtraFieldQuantity3.Text = inv_Item.ExtraFieldQuantity3.ToString();
txtExtraFieldQuantity4.Text = inv_Item.ExtraFieldQuantity4.ToString();
txtExtraFieldQuantity5.Text = inv_Item.ExtraFieldQuantity5.ToString();
txtExtraField1.Text = inv_Item.ExtraField1;
txtExtraField2.Text = inv_Item.ExtraField2;
txtExtraField3.Text = inv_Item.ExtraField3;
txtExtraField4.Text = inv_Item.ExtraField4;
txtExtraField5.Text = inv_Item.ExtraField5;
txtExtraField6.Text = inv_Item.ExtraField6;
txtExtraField7.Text = inv_Item.ExtraField7;
txtExtraField8.Text = inv_Item.ExtraField8;
txtExtraField9.Text = inv_Item.ExtraField9;
txtExtraField10.Text = inv_Item.ExtraField10;
txtAddedBy.Text = inv_Item.AddedBy.ToString();
txtUpdatedBy.Text = inv_Item.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_Item.UpdatedDate.ToString("yyyy-MM-dd hh:mm tt");
ddlRowStatus.SelectedValue = inv_Item.RowStatusID.ToString();
}
public bool UpdateInv_Item(Inv_Item inv_Item)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Item", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_ItemID", SqlDbType.Int).Value = inv_Item.Inv_ItemID;
cmd.Parameters.Add("@ItemName", SqlDbType.NVarChar).Value = inv_Item.ItemName;
cmd.Parameters.Add("@PurchaseID", SqlDbType.Int).Value = inv_Item.PurchaseID;
cmd.Parameters.Add("@ItemCode", SqlDbType.NChar).Value = inv_Item.ItemCode;
cmd.Parameters.Add("@RawMaterialID", SqlDbType.Int).Value = inv_Item.RawMaterialID;
cmd.Parameters.Add("@StoreID", SqlDbType.Int).Value = inv_Item.StoreID;
cmd.Parameters.Add("@QualityUnitID", SqlDbType.Int).Value = inv_Item.QualityUnitID;
cmd.Parameters.Add("@QualityValue", SqlDbType.Decimal).Value = inv_Item.QualityValue;
cmd.Parameters.Add("@QuantityUnitID", SqlDbType.Int).Value = inv_Item.QuantityUnitID;
cmd.Parameters.Add("@PricePerUnit", SqlDbType.Decimal).Value = inv_Item.PricePerUnit;
cmd.Parameters.Add("@PurchasedQuantity", SqlDbType.Decimal).Value = inv_Item.PurchasedQuantity;
cmd.Parameters.Add("@IssueReturedQuantity", SqlDbType.Decimal).Value = inv_Item.IssueReturedQuantity;
cmd.Parameters.Add("@UtilizedQuantity", SqlDbType.Decimal).Value = inv_Item.UtilizedQuantity;
cmd.Parameters.Add("@LostQuantity", SqlDbType.Decimal).Value = inv_Item.LostQuantity;
cmd.Parameters.Add("@ExtraFieldQuantity1", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity1;
cmd.Parameters.Add("@ExtraFieldQuantity2", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity2;
cmd.Parameters.Add("@ExtraFieldQuantity3", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity3;
cmd.Parameters.Add("@ExtraFieldQuantity4", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity4;
cmd.Parameters.Add("@ExtraFieldQuantity5", SqlDbType.Decimal).Value = inv_Item.ExtraFieldQuantity5;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_Item.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Item.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Item.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Item.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Item.ExtraField5;
cmd.Parameters.Add("@ExtraField6", SqlDbType.NVarChar).Value = inv_Item.ExtraField6;
cmd.Parameters.Add("@ExtraField7", SqlDbType.NVarChar).Value = inv_Item.ExtraField7;
cmd.Parameters.Add("@ExtraField8", SqlDbType.NVarChar).Value = inv_Item.ExtraField8;
cmd.Parameters.Add("@ExtraField9", SqlDbType.NVarChar).Value = inv_Item.ExtraField9;
cmd.Parameters.Add("@ExtraField10", SqlDbType.NVarChar).Value = inv_Item.ExtraField10;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Item.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Item.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Item.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Item.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Item.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
lblMsgWornInput.Visible = false;
if (txtPurchasedQuantity.Text == "" ||
txtPricePerUnit.Text == "" ||
txtItemCode.Text == "" ||
ddlQuantityUnit.SelectedValue == "0"
)
{
lblMsgWornInput.Visible = true;
return;
}
if (ddlRawMaterial.SelectedValue == "0")
{
showAlartMessage("Please select the Rawmaterial");
return;
}
List <Inv_Item> PurchasedItem = new List <Inv_Item>();
PurchasedItem = loadFromTheGrid();
Inv_Item inv_Item = new Inv_Item();
inv_Item.ItemName = ddlRawMaterial.SelectedItem.Text;
inv_Item.PurchaseID = PurchasedItem.Count + 1;
inv_Item.ItemCode = decimal.Parse(txtItemCode.Text).ToString("000.00");
inv_Item.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue.Split('@')[1]);
inv_Item.StoreID = 2;
inv_Item.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
inv_Item.QualityUnitName = ddlQualityUnit.SelectedItem.Text;
inv_Item.QualityValue = Decimal.Parse(txtQualityValue.Text == ""? "0":txtQualityValue.Text);
inv_Item.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
inv_Item.QuantityUnitName = ddlQuantityUnit.SelectedItem.Text;
inv_Item.PricePerUnit = Decimal.Parse(txtPricePerUnit.Text);
inv_Item.PurchasedQuantity = Decimal.Parse(txtPurchasedQuantity.Text);
inv_Item.PurchasedQuantityPrice = inv_Item.PricePerUnit * inv_Item.PurchasedQuantity;
inv_Item.IssueReturedQuantity = 0;
inv_Item.UtilizedQuantity = 0;
inv_Item.LostQuantity = 0;
inv_Item.ExtraFieldQuantity1 = Decimal.Parse(txtPurchasedQuantity.Text);
inv_Item.ExtraFieldQuantity2 = 0;
inv_Item.ExtraFieldQuantity3 = 0;
inv_Item.ExtraFieldQuantity4 = 0;
inv_Item.ExtraFieldQuantity5 = 0;
inv_Item.ExtraField1 = "";
inv_Item.ExtraField2 = "";
inv_Item.ExtraField3 = ddlProduct.SelectedValue;
inv_Item.ExtraField4 = ddlFabricsTypeID.SelectedValue;
inv_Item.ExtraField5 = ddlColor.SelectedValue;
inv_Item.ExtraField6 = "";
inv_Item.ExtraField7 = "";
inv_Item.ExtraField8 = "";
inv_Item.ExtraField9 = "";
inv_Item.ExtraField10 = "";
inv_Item.AddedBy = getLogin().LoginID;
inv_Item.AddedDate = DateTime.Now;
inv_Item.UpdatedBy = getLogin().LoginID;
inv_Item.UpdatedDate = DateTime.Now;
inv_Item.RowStatusID = 1;
//int resutl = Inv_ItemManager.InsertInv_Item(inv_Item);
PurchasedItem.Add(inv_Item);
showInv_ItemGrid(PurchasedItem);
btnClear_Click(this, new EventArgs());
}
public static int InsertInv_Item(Inv_Item inv_Item)
{
SqlInv_ItemProvider sqlInv_ItemProvider = new SqlInv_ItemProvider();
return sqlInv_ItemProvider.InsertInv_Item(inv_Item);
}
public static Inv_Item GetInv_ItemByID(int id)
{
Inv_Item inv_Item = new Inv_Item();
SqlInv_ItemProvider sqlInv_ItemProvider = new SqlInv_ItemProvider();
inv_Item = sqlInv_ItemProvider.GetInv_ItemByID(id);
return inv_Item;
}
public static bool UpdateInv_Item(Inv_Item inv_Item)
{
SqlInv_ItemProvider sqlInv_ItemProvider = new SqlInv_ItemProvider();
return(sqlInv_ItemProvider.UpdateInv_Item(inv_Item));
}
public static int InsertInv_Item(Inv_Item inv_Item)
{
SqlInv_ItemProvider sqlInv_ItemProvider = new SqlInv_ItemProvider();
return(sqlInv_ItemProvider.InsertInv_Item(inv_Item));
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_Item inv_Item = new Inv_Item();
inv_Item = Inv_ItemManager.GetInv_ItemByID(Int32.Parse(Request.QueryString["inv_ItemID"]));
Inv_Item tempInv_Item = new Inv_Item();
tempInv_Item.Inv_ItemID = inv_Item.Inv_ItemID;
tempInv_Item.ItemName = txtItemName.Text;
tempInv_Item.PurchaseID = Int32.Parse(ddlPurchase.SelectedValue);
tempInv_Item.ItemCode = txtItemCode.Text;
tempInv_Item.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
tempInv_Item.StoreID = Int32.Parse(ddlStore.SelectedValue);
tempInv_Item.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
tempInv_Item.QualityValue = Decimal.Parse(txtQualityValue.Text);
tempInv_Item.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
tempInv_Item.PricePerUnit = Decimal.Parse(txtPricePerUnit.Text);
tempInv_Item.PurchasedQuantity = Decimal.Parse(txtPurchasedQuantity.Text);
tempInv_Item.IssueReturedQuantity = Decimal.Parse(txtIssueReturedQuantity.Text);
tempInv_Item.UtilizedQuantity = Decimal.Parse(txtUtilizedQuantity.Text);
tempInv_Item.LostQuantity = Decimal.Parse(txtLostQuantity.Text);
tempInv_Item.ExtraFieldQuantity1 = Decimal.Parse(txtExtraFieldQuantity1.Text);
tempInv_Item.ExtraFieldQuantity2 = Decimal.Parse(txtExtraFieldQuantity2.Text);
tempInv_Item.ExtraFieldQuantity3 = Decimal.Parse(txtExtraFieldQuantity3.Text);
tempInv_Item.ExtraFieldQuantity4 = Decimal.Parse(txtExtraFieldQuantity4.Text);
tempInv_Item.ExtraFieldQuantity5 = Decimal.Parse(txtExtraFieldQuantity5.Text);
tempInv_Item.ExtraField1 = txtExtraField1.Text;
tempInv_Item.ExtraField2 = txtExtraField2.Text;
tempInv_Item.ExtraField3 = txtExtraField3.Text;
tempInv_Item.ExtraField4 = txtExtraField4.Text;
tempInv_Item.ExtraField5 = txtExtraField5.Text;
tempInv_Item.ExtraField6 = txtExtraField6.Text;
tempInv_Item.ExtraField7 = txtExtraField7.Text;
tempInv_Item.ExtraField8 = txtExtraField8.Text;
tempInv_Item.ExtraField9 = txtExtraField9.Text;
tempInv_Item.ExtraField10 = txtExtraField10.Text;
tempInv_Item.AddedBy =getLogin().LoginID;
tempInv_Item.AddedDate = DateTime.Now;
tempInv_Item.UpdatedBy = getLogin().LoginID;
tempInv_Item.UpdatedDate = DateTime.Now;
tempInv_Item.RowStatusID = 1;
bool result = Inv_ItemManager.UpdateInv_Item(tempInv_Item);
Response.Redirect("ItemHistory.aspx?ItemID=" + inv_Item.Inv_ItemID.ToString());
}
public Inv_Item GetInv_ItemFromReader(IDataReader reader)
{
try
{
Inv_Item inv_Item = new Inv_Item
(
(int)reader["Inv_ItemID"],
reader["ItemName"].ToString(),
(int)reader["PurchaseID"],
reader["ItemCode"].ToString(),
(int)reader["RawMaterialID"],
(int)reader["StoreID"],
(int)reader["QualityUnitID"],
(decimal)reader["QualityValue"],
(int)reader["QuantityUnitID"],
(decimal)reader["PricePerUnit"],
(decimal)reader["PurchasedQuantity"],
(decimal)reader["IssueReturedQuantity"],
(decimal)reader["UtilizedQuantity"],
(decimal)reader["LostQuantity"],
(decimal)reader["ExtraFieldQuantity1"],
(decimal)reader["ExtraFieldQuantity2"],
(decimal)reader["ExtraFieldQuantity3"],
(decimal)reader["ExtraFieldQuantity4"],
(decimal)reader["ExtraFieldQuantity5"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
reader["ExtraField6"].ToString(),
reader["ExtraField7"].ToString(),
reader["ExtraField8"].ToString(),
reader["ExtraField9"].ToString(),
reader["ExtraField10"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
try { inv_Item.QualityUnitName = inv_Item.ExtraField1; }
catch (Exception) { }
try { inv_Item.PurchasedQuantityPrice = (inv_Item.PricePerUnit * inv_Item.PurchasedQuantity); }
catch (Exception) { }
try { inv_Item.QuantityUnitName = inv_Item.ExtraField2; }
catch (Exception) { }
try { inv_Item.RawMaterialName = reader["RawMaterialName"].ToString(); }
catch (Exception) { }
try { inv_Item.RawMaterialTypeID = (int)reader["ACC_HeadTypeID"]; }
catch (Exception) { inv_Item.RawMaterialTypeID = 0; }
try { inv_Item.RawMaterialTypeName = reader["HeadTypeName"].ToString(); }
catch (Exception) { inv_Item.RawMaterialTypeName = ""; }
return(inv_Item);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateInv_Item(Inv_Item inv_Item)
{
SqlInv_ItemProvider sqlInv_ItemProvider = new SqlInv_ItemProvider();
return sqlInv_ItemProvider.UpdateInv_Item(inv_Item);
}
private void loadData()
{
int workStationID = 0;
try
{
workStationID = Int32.Parse(Request.QueryString["WorkStationID"]);
}
catch (Exception ex)
{
workStationID = 0;
}
int RawmaterialsTypeID = 0;
try
{
RawmaterialsTypeID = Int32.Parse(Request.QueryString["RawmaterialsTypeID"]);
}
catch (Exception ex)
{
RawmaterialsTypeID = 0;
}
int ItemID = 0;
try
{
ItemID = Int32.Parse(Request.QueryString["ItemID"]);
}
catch (Exception ex)
{
ItemID = 0;
}
//lblStockDate.Text = DateTime.Parse(Request.QueryString["date"]).ToString("dd MMM yyyy");
string fromDate = (Request.QueryString["FromDate"] != null ? Request.QueryString["FromDate"].ToString() : "");
string toDate = (Request.QueryString["ToDate"] != null ? Request.QueryString["ToDate"].ToString() : "");
lblStockDate.Text = DateTime.Parse(fromDate).ToString("dd/MM/yyyy") + " to " + DateTime.Parse(toDate).ToString("dd/MM/yyyy");
//purchase info
string sql = @"declare @FromDate datetime
declare @ToDate datetime
declare @WorkStationID int
set @FromDate='" + fromDate + @"'
set @ToDate='" + toDate + @"'
Declare @ACC_HeadTypeID int
set @ACC_HeadTypeID =" + RawmaterialsTypeID + @"
set @WorkStationID=" + workStationID + @"
--Issue Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMaster on Inv_IssueMaster.Inv_IssueMasterID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=2
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_IssueMaster.WorkSatationID=@WorkStationID
and Inv_IssueMaster.IssueDate <@FromDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
--Issue Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMaster on Inv_IssueMaster.Inv_IssueMasterID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=2
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_IssueMaster.WorkSatationID=@WorkStationID
and Inv_IssueMaster.IssueDate >= @FromDate and Inv_IssueMaster.IssueDate <= @ToDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
--Issue Return Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMasterReturn on Inv_IssueMasterReturn.Inv_IssueMasterReturnID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=3
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_IssueMasterReturn.WorkSatationID=@WorkStationID
and Inv_IssueMasterReturn.IssueReturnDate <@FromDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
--Issue Return Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMasterReturn on Inv_IssueMasterReturn.Inv_IssueMasterReturnID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=3
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_IssueMasterReturn.WorkSatationID=@WorkStationID
and Inv_IssueMasterReturn.IssueReturnDate >= @FromDate and Inv_IssueMasterReturn.IssueReturnDate <= @ToDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
--Wastage Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Wastage on Inv_Wastage.Inv_WastageID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=6
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_Wastage.WorkSatationID =@WorkStationID
and Inv_Wastage.WastageDate <@FromDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
--Wastage Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Wastage on Inv_Wastage.Inv_WastageID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=6
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_Wastage.WorkSatationID =@WorkStationID
and Inv_Wastage.WastageDate >= @FromDate and Inv_Wastage.WastageDate <= @ToDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
--Production Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Utilization on Inv_Utilization.Inv_UtilizationID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=4
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_Utilization.WorkSatationID =@WorkStationID
and Inv_Utilization.UtilizationDate <@FromDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
--Production Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice
,Inv_Item.Inv_ItemID as RawMaterialID
,Inv_Item.ItemCode as ExtraField1,Inv_Item.ItemName as ChartOfAccountLabel4Text
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Utilization on Inv_Utilization.Inv_UtilizationID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=4
and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID
and Inv_ItemTransaction.RowStatusID=1
and Inv_Utilization.WorkSatationID =@WorkStationID
and Inv_Utilization.UtilizationDate >= @FromDate and Inv_Utilization.UtilizationDate <= @ToDate
group by Inv_Item.ItemCode, Inv_Item.Inv_ItemID,Inv_Item.ItemName
order by Inv_Item.ItemCode
";
DataSet ds= CommonManager.SQLExec(sql);
List<Inv_Item> items = new List<Inv_Item>();
foreach (DataTable tbl in ds.Tables)
{
foreach (DataRow dr in tbl.Rows)
{
Inv_Item newItem = new Inv_Item();
bool isFound=false;
foreach (Inv_Item inv_Item in items)
{
if (dr["RawMaterialID"].ToString() == inv_Item.Inv_ItemID.ToString())
{
isFound = true;
break;
}
}
if (!isFound)
{
newItem.Inv_ItemID = int.Parse(dr["RawMaterialID"].ToString());
newItem.ItemCode = dr["ExtraField1"].ToString();
newItem.ItemName = dr["ChartOfAccountLabel4Text"].ToString();
newItem.ExtraField1 = "0@0";
newItem.ExtraField2 = "0@0";
newItem.ExtraField3 = "0@0";
newItem.ExtraField4 = "0@0";
newItem.ExtraField5 = "0@0";
newItem.ExtraField6 = "0@0";
newItem.ExtraField7 = "0@0";
newItem.ExtraField8 = "0@0";
newItem.ExtraField9 = "0@0";
newItem.ExtraField10 = "0@0";
newItem.ExtraFieldQuantity1=0;
newItem.ExtraFieldQuantity2=0;
newItem.ExtraFieldQuantity3=0;
newItem.ExtraFieldQuantity4=0;
newItem.ExtraFieldQuantity5 = 0;
newItem.IssueReturedQuantity = 0;
newItem.LostQuantity = 0;
newItem.PurchasedQuantity = 0;
newItem.PurchasedQuantityPrice = 0;
newItem.QualityValue = 0;
items.Add(newItem);
}
}
}
sql = "";
foreach (Inv_Item inv_Item in items)
{
sql += @"select top 1 Inv_QuantityUnit.QuantityUnitName,'" +inv_Item.Inv_ItemID.ToString()+@"' as RawMetarialID from Inv_Item
inner join Inv_QuantityUnit on Inv_QuantityUnit.Inv_QuantityUnitID= Inv_Item.QuantityUnitID
where RawMaterialID=" +inv_Item.Inv_ItemID.ToString()+";";
}
// DataSet ds2 = CommonManager.SQLExec(sql);
for (int i = 0; i < items.Count; i++)
{
items[i].QuantityUnitName = "Ps";
//if (ds2.Tables[i].Rows[0]["RawMetarialID"].ToString() == items[i].Inv_ItemID.ToString())
//{
// items[i].QuantityUnitName = ds2.Tables[i].Rows[0]["QuantityUnitName"].ToString();
//}
}
foreach (Inv_Item inv_Item in items)
{
//Issue Stock
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField7 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Issue Current
foreach (DataRow dr in ds.Tables[1].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField8 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Issue Return Stock
foreach (DataRow dr in ds.Tables[2].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField9 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Issue Return Current
foreach (DataRow dr in ds.Tables[3].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField10 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Wastage Stock
foreach (DataRow dr in ds.Tables[4].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity1 = decimal.Parse(dr["Qty"].ToString());
inv_Item.LostQuantity = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Wastage Current
foreach (DataRow dr in ds.Tables[5].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity2 = decimal.Parse(dr["Qty"].ToString());
inv_Item.QualityValue = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Utilization Stock
foreach (DataRow dr in ds.Tables[6].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity3 = decimal.Parse(dr["Qty"].ToString());
inv_Item.UtilizedQuantity = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Utilization Current
foreach (DataRow dr in ds.Tables[7].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity4 = decimal.Parse(dr["Qty"].ToString());
inv_Item.ExtraFieldQuantity5 = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Opining Stock
inv_Item.PurchasedQuantity =
decimal.Parse(inv_Item.ExtraField7.Split('@')[0]) //Issue
-
decimal.Parse(inv_Item.ExtraField9.Split('@')[0]) //Issue Return
-
inv_Item.ExtraFieldQuantity1 //Wastage
-
inv_Item.ExtraFieldQuantity3; //Utilization
//Stock in hand
inv_Item.PurchasedQuantityPrice =
inv_Item.PurchasedQuantity
+
decimal.Parse(inv_Item.ExtraField8.Split('@')[0]) //Issue
-
decimal.Parse(inv_Item.ExtraField10.Split('@')[0]) //Issue Return
-
inv_Item.ExtraFieldQuantity2 //Wastage
-
inv_Item.ExtraFieldQuantity4; //Utilization
//Stock Price
inv_Item.IssueReturedQuantity =
decimal.Parse(inv_Item.ExtraField7.Split('@')[1]) //Issue
-
decimal.Parse(inv_Item.ExtraField9.Split('@')[1]) //Issue Return
-
inv_Item.LostQuantity //Wastage
-
inv_Item.UtilizedQuantity //Utilization
+
decimal.Parse(inv_Item.ExtraField8.Split('@')[1]) //Issue
-
decimal.Parse(inv_Item.ExtraField10.Split('@')[1]) //Issue Return
-
inv_Item.QualityValue //Wastage
-
inv_Item.ExtraFieldQuantity5; //Utilization
//keep on the quantity
inv_Item.ExtraField1 = inv_Item.ExtraField1.Split('@')[0];
inv_Item.ExtraField2 = inv_Item.ExtraField2.Split('@')[0];
inv_Item.ExtraField3 = inv_Item.ExtraField3.Split('@')[0];
inv_Item.ExtraField4 = inv_Item.ExtraField4.Split('@')[0];
inv_Item.ExtraField5 = inv_Item.ExtraField5.Split('@')[0];
inv_Item.ExtraField6 = inv_Item.ExtraField6.Split('@')[0];
inv_Item.ExtraField7 = inv_Item.ExtraField7.Split('@')[0];
inv_Item.ExtraField8 = inv_Item.ExtraField8.Split('@')[0];
inv_Item.ExtraField9 = inv_Item.ExtraField9.Split('@')[0];
inv_Item.ExtraField10 = inv_Item.ExtraField10.Split('@')[0];
}
decimal OpiningQuantity = 0;
decimal PurchasedQuantity = 0;
decimal PurchaseAdjustMent = 0;
decimal PurchaseReturn = 0;
decimal IssuedQuantity = 0;
decimal IssueReturedQuantity = 0;
decimal WastageQuantity = 0;
decimal UtilizedQuantity = 0;
decimal AvailableInStore = 0;
decimal StoreTotalAmount = 0;
int serialNo = 1;
string htmlTable = @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
<tr id='tableHeader'>
<td style='border-left:0px;'>S/L</td>
<td>Item Code</td>
<td>Item Name</td>
<td>Unit</td>
<td>Opining</td>
<td><a href='IssueReportPrint.aspx?RawmaterialsTypeID=" + RawmaterialsTypeID + @"&WorkstationID=0&FromDate=" + fromDate + "&ToDate=" + toDate + "'>Issue<br/>Quantity" + @"</a></td></td>
<td>Issue<br/>Return<br/>Quantity</td>
<td>Wastage<br/>Quantity</td>
<td>Utlized<br/>Quantity</td>
<td>Stock<br/>Quantity</td>
<td>Stock<br/>Amount</td>
</tr>";
foreach (Inv_Item inv_Item in items)
{
if (inv_Item.PurchasedQuantity == 0
&& inv_Item.PurchasedQuantityPrice == 0 &&
inv_Item.ExtraField2 == "0"&&
inv_Item.ExtraField4== "0"&&
inv_Item.ExtraField6 == "0"&&
inv_Item.ExtraField8 == "0"&&
inv_Item.ExtraField10 == "0"&&
inv_Item.ExtraFieldQuantity2==0 &&
inv_Item.ExtraFieldQuantity4==0
)
{
continue;
}
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
<td>" +inv_Item.ItemCode + @"</td>
<td>" + inv_Item.ItemName + @"</td>
<td style='color:white;'>" + inv_Item.QuantityUnitName + @"</td>
<td style='text-align:right;'>" + inv_Item.PurchasedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + decimal.Parse(inv_Item.ExtraField8).ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + decimal.Parse(inv_Item.ExtraField10).ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.ExtraFieldQuantity2.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.ExtraFieldQuantity4.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.PurchasedQuantityPrice.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.IssueReturedQuantity.ToString("0,0.00") + @"</td>
</tr>";
OpiningQuantity += inv_Item.PurchasedQuantity;
PurchasedQuantity += decimal.Parse(inv_Item.ExtraField2);
PurchaseAdjustMent += decimal.Parse(inv_Item.ExtraField4);
PurchaseReturn += decimal.Parse(inv_Item.ExtraField6);
IssuedQuantity += decimal.Parse(inv_Item.ExtraField8);
IssueReturedQuantity += decimal.Parse(inv_Item.ExtraField10);
WastageQuantity += inv_Item.ExtraFieldQuantity2;
UtilizedQuantity += inv_Item.ExtraFieldQuantity4;
AvailableInStore += inv_Item.PurchasedQuantityPrice;
StoreTotalAmount += inv_Item.IssueReturedQuantity;
}
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td> </td>
<td>Total</td>
<td style='text-align:right;'>" + OpiningQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + IssuedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + IssueReturedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + WastageQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + UtilizedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + AvailableInStore.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + StoreTotalAmount.ToString("0,0.00") + @"</td>
</tr></table>";
lblItemList.Text = htmlTable;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
lblMsgWornInput.Visible = false ;
if (txtPurchasedQuantity.Text == ""
|| txtPricePerUnit.Text == ""
|| txtItemCode.Text ==""
|| ddlQuantityUnit.SelectedValue =="0"
)
{
lblMsgWornInput.Visible = true;
return; }
if (ddlRawMaterial.SelectedValue == "0")
{
showAlartMessage("Please select the Rawmaterial");
return;
}
List<Inv_Item> PurchasedItem = new List<Inv_Item>();
PurchasedItem = loadFromTheGrid();
Inv_Item inv_Item = new Inv_Item();
inv_Item.ItemName = ddlRawMaterial.SelectedItem.Text;
inv_Item.PurchaseID = PurchasedItem.Count+1;
inv_Item.ItemCode = decimal.Parse(txtItemCode.Text).ToString("000.00");
inv_Item.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue.Split('@')[1]);
inv_Item.StoreID = 2;
inv_Item.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
inv_Item.QualityUnitName = ddlQualityUnit.SelectedItem.Text;
inv_Item.QualityValue = Decimal.Parse(txtQualityValue.Text==""? "0":txtQualityValue.Text);
inv_Item.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
inv_Item.QuantityUnitName = ddlQuantityUnit.SelectedItem.Text;
inv_Item.PricePerUnit = Decimal.Parse(txtPricePerUnit.Text);
inv_Item.PurchasedQuantity = Decimal.Parse(txtPurchasedQuantity.Text);
inv_Item.PurchasedQuantityPrice = inv_Item.PricePerUnit * inv_Item.PurchasedQuantity;
inv_Item.IssueReturedQuantity = 0;
inv_Item.UtilizedQuantity = 0;
inv_Item.LostQuantity =0;
inv_Item.ExtraFieldQuantity1 = Decimal.Parse(txtPurchasedQuantity.Text);
inv_Item.ExtraFieldQuantity2 = 0;
inv_Item.ExtraFieldQuantity3 = 0;
inv_Item.ExtraFieldQuantity4 = 0;
inv_Item.ExtraFieldQuantity5 = 0;
inv_Item.ExtraField1 = "";
inv_Item.ExtraField2 = "";
inv_Item.ExtraField3 = ddlProduct.SelectedValue;
inv_Item.ExtraField4 = ddlFabricsTypeID.SelectedValue;
inv_Item.ExtraField5 = ddlColor.SelectedValue;
inv_Item.ExtraField6 = "";
inv_Item.ExtraField7 = "";
inv_Item.ExtraField8 = "";
inv_Item.ExtraField9 = "";
inv_Item.ExtraField10 = "";
inv_Item.AddedBy =getLogin().LoginID;
inv_Item.AddedDate = DateTime.Now;
inv_Item.UpdatedBy = getLogin().LoginID;
inv_Item.UpdatedDate = DateTime.Now;
inv_Item.RowStatusID = 1;
//int resutl = Inv_ItemManager.InsertInv_Item(inv_Item);
PurchasedItem.Add(inv_Item);
showInv_ItemGrid(PurchasedItem);
btnClear_Click(this, new EventArgs());
}
private List<Inv_Item> loadFromTheGrid()
{
List<Inv_Item> PurchasedItem = new List<Inv_Item>();
int serial = 1;
foreach (GridViewRow gvr in gvInv_Item.Rows)
{
Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID");
Label lblItemName = (Label)gvr.FindControl("lblItemName");
HiddenField hfRawMaterialID = (HiddenField)gvr.FindControl("hfRawMaterialID");
HiddenField hfQualityUnitID = (HiddenField)gvr.FindControl("hfQualityUnitID");
HiddenField hfQuantityUnitID = (HiddenField)gvr.FindControl("hfQuantityUnitID");
HiddenField hfExtraField3 = (HiddenField)gvr.FindControl("hfExtraField3");
HiddenField hfExtraField4 = (HiddenField)gvr.FindControl("hfExtraField4");
HiddenField hfExtraField5 = (HiddenField)gvr.FindControl("hfExtraField5");
Label lblItemCode = (Label)gvr.FindControl("lblItemCode");
Label lblQualityValue = (Label)gvr.FindControl("lblQualityValue");
Label lblQualityUnitName = (Label)gvr.FindControl("lblQualityUnitName");
Label lblPurchasedQuantity = (Label)gvr.FindControl("lblPurchasedQuantity");
Label lblQuantityUnitName = (Label)gvr.FindControl("lblQuantityUnitName");
Label lblPricePerUnit = (Label)gvr.FindControl("lblPricePerUnit");
Inv_Item inv_Item = new Inv_Item();
inv_Item.ItemName = lblItemName.Text;
inv_Item.PurchaseID = serial++;
inv_Item.ItemCode = lblItemCode.Text;
inv_Item.RawMaterialID = Int32.Parse(hfRawMaterialID.Value);
inv_Item.StoreID = 2;
inv_Item.QualityUnitID = Int32.Parse(hfQualityUnitID.Value);
inv_Item.QualityUnitName = lblQualityUnitName.Text;
inv_Item.QualityValue = Decimal.Parse(lblQualityValue.Text);
inv_Item.QuantityUnitID = Int32.Parse(hfQuantityUnitID.Value);
inv_Item.QuantityUnitName =lblQuantityUnitName.Text;
inv_Item.PricePerUnit = Decimal.Parse(lblPricePerUnit.Text);
inv_Item.PurchasedQuantity = Decimal.Parse(lblPurchasedQuantity.Text);
inv_Item.PurchasedQuantityPrice = inv_Item.PricePerUnit * inv_Item.PurchasedQuantity;
inv_Item.IssueReturedQuantity = 0;
inv_Item.UtilizedQuantity = 0;
inv_Item.LostQuantity =0;
inv_Item.ExtraFieldQuantity1 = inv_Item.PurchasedQuantity;
inv_Item.ExtraFieldQuantity2 = 0;
inv_Item.ExtraFieldQuantity3 = 0;
inv_Item.ExtraFieldQuantity4 = 0;
inv_Item.ExtraFieldQuantity5 = 0;
inv_Item.ExtraField1 = "";
inv_Item.ExtraField2 = "";
inv_Item.ExtraField3 = hfExtraField3.Value;
inv_Item.ExtraField4 = hfExtraField4.Value;
inv_Item.ExtraField5 = hfExtraField5.Value;
inv_Item.ExtraField6 = "";
inv_Item.ExtraField7 = "";
inv_Item.ExtraField8 = "";
inv_Item.ExtraField9 = "";
inv_Item.ExtraField10 = "";
inv_Item.AddedBy =getLogin().LoginID;
inv_Item.AddedDate = DateTime.Now;
inv_Item.UpdatedBy = getLogin().LoginID;
inv_Item.UpdatedDate = DateTime.Now;
inv_Item.RowStatusID = 1;
PurchasedItem.Add(inv_Item);
}
return PurchasedItem;
}
public Inv_Item GetInv_ItemFromReader(IDataReader reader)
{
try
{
Inv_Item inv_Item = new Inv_Item
(
(int)reader["Inv_ItemID"],
reader["ItemName"].ToString(),
(int)reader["PurchaseID"],
reader["ItemCode"].ToString(),
(int)reader["RawMaterialID"],
(int)reader["StoreID"],
(int)reader["QualityUnitID"],
(decimal)reader["QualityValue"],
(int)reader["QuantityUnitID"],
(decimal)reader["PricePerUnit"],
(decimal)reader["PurchasedQuantity"],
(decimal)reader["IssueReturedQuantity"],
(decimal)reader["UtilizedQuantity"],
(decimal)reader["LostQuantity"],
(decimal)reader["ExtraFieldQuantity1"],
(decimal)reader["ExtraFieldQuantity2"],
(decimal)reader["ExtraFieldQuantity3"],
(decimal)reader["ExtraFieldQuantity4"],
(decimal)reader["ExtraFieldQuantity5"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
reader["ExtraField6"].ToString(),
reader["ExtraField7"].ToString(),
reader["ExtraField8"].ToString(),
reader["ExtraField9"].ToString(),
reader["ExtraField10"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
try { inv_Item.QualityUnitName = inv_Item.ExtraField1; }
catch (Exception) { }
try { inv_Item.PurchasedQuantityPrice =( inv_Item.PricePerUnit * inv_Item.PurchasedQuantity); }
catch (Exception) { }
try { inv_Item.QuantityUnitName = inv_Item.ExtraField2; }
catch (Exception) { }
try { inv_Item.RawMaterialName = reader["RawMaterialName"].ToString(); }
catch (Exception) { }
try { inv_Item.RawMaterialTypeID = (int)reader["ACC_HeadTypeID"]; }
catch (Exception) { inv_Item.RawMaterialTypeID = 0; }
try { inv_Item.RawMaterialTypeName = reader["HeadTypeName"].ToString(); }
catch (Exception) { inv_Item.RawMaterialTypeName = ""; }
return inv_Item;
}
catch(Exception ex)
{
return null;
}
}
private void loadData()
{
int suppliyerID = 0;
try
{
suppliyerID = Int32.Parse(Request.QueryString["SuppliyerID"]);
}
catch (Exception ex)
{
suppliyerID = 0;
}
int RawmaterialsTypeID = 0;
try
{
RawmaterialsTypeID = Int32.Parse(Request.QueryString["RawmaterialsTypeID"]);
}
catch (Exception ex)
{
RawmaterialsTypeID = 0;
}
int ItemID = 0;
try
{
ItemID = Int32.Parse(Request.QueryString["ItemID"]);
}
catch (Exception ex)
{
ItemID = 0;
}
//lblStockDate.Text = DateTime.Parse(Request.QueryString["date"]).ToString("dd MMM yyyy");
string fromDate = (Request.QueryString["FromDate"] != null ? Request.QueryString["FromDate"].ToString() : "");
string toDate = (Request.QueryString["ToDate"] != null ? Request.QueryString["ToDate"].ToString() : "");
lblStockDate.Text = DateTime.Parse(fromDate).ToString("dd/MM/yyyy") + " to " + DateTime.Parse(toDate).ToString("dd/MM/yyyy");
//purchase info
string rowMetarialSQL = "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID";
string sql = @"declare @FromDate datetime
declare @ToDate datetime
set @FromDate='" + fromDate + @"'
set @ToDate='" + toDate + @"'
Declare @ACC_HeadTypeID int
set @ACC_HeadTypeID =" + RawmaterialsTypeID + @"
--purchase Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Purchase on Inv_Purchase.Inv_PurchaseID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=8
" + (RawmaterialsTypeID != 0?"and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID":"") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_Purchase.PurchseDate < @FromDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--purchase Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Purchase on Inv_Purchase.Inv_PurchaseID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=8
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_Purchase.PurchseDate >= @FromDate and Inv_Purchase.PurchseDate <= @ToDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--purchase Adjustment Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_PurchaseAdjustment on Inv_PurchaseAdjustment.Inv_PurchaseAdjustmentID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=7
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_PurchaseAdjustment.PurchseAdjustmentDate < @FromDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--purchase Adjustment current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_PurchaseAdjustment on Inv_PurchaseAdjustment.Inv_PurchaseAdjustmentID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=7
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_PurchaseAdjustment.PurchseAdjustmentDate >= @FromDate and Inv_PurchaseAdjustment.PurchseAdjustmentDate <= @ToDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Purchase Return Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_PurchaseReturn on Inv_PurchaseReturn.Inv_PurchaseReturenID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=1
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_PurchaseReturn.PurchseReturenDate < @FromDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Purchase Return Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_PurchaseReturn on Inv_PurchaseReturn.Inv_PurchaseReturenID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=1
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_PurchaseReturn.PurchseReturenDate >= @FromDate and Inv_PurchaseReturn.PurchseReturenDate <= @ToDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Issue Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMaster on Inv_IssueMaster.Inv_IssueMasterID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=2
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_IssueMaster.IssueDate <@FromDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Issue Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMaster on Inv_IssueMaster.Inv_IssueMasterID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=2
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_IssueMaster.IssueDate >= @FromDate and Inv_IssueMaster.IssueDate <= @ToDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Issue Return Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMasterReturn on Inv_IssueMasterReturn.Inv_IssueMasterReturnID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=3
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_IssueMasterReturn.IssueReturnDate <@FromDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Issue Return Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_IssueMasterReturn on Inv_IssueMasterReturn.Inv_IssueMasterReturnID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=3
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_IssueMasterReturn.IssueReturnDate >= @FromDate and Inv_IssueMasterReturn.IssueReturnDate <= @ToDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Wastage Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Wastage on Inv_Wastage.Inv_WastageID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=6
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1
and Inv_Wastage.WastageDate <@FromDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Wastage Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Wastage on Inv_Wastage.Inv_WastageID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=6
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1 and
Inv_Wastage.WastageDate >= @FromDate and Inv_Wastage.WastageDate <= @ToDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Production Stock
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Utilization on Inv_Utilization.Inv_UtilizationID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=4
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1
and Inv_Utilization.UtilizationDate <@FromDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
--Production Current
Select Sum(Inv_ItemTransaction.Quantity) as Qty, Sum(Inv_ItemTransaction.Quantity * Inv_Item.PricePerUnit) as QtyPrice,Inv_Item.RawMaterialID
,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
from Inv_ItemTransaction
inner join Inv_Item on Inv_Item.Inv_ItemID = Inv_ItemTransaction.ItemID
inner join Inv_Utilization on Inv_Utilization.Inv_UtilizationID = Inv_ItemTransaction.ReferenceID
inner join ACC_ChartOfAccountLabel4 on Inv_Item.RawMaterialID = ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID
where Inv_ItemTransaction.ItemTrasactionTypeID=4
" + (RawmaterialsTypeID != 0 ? "and ACC_ChartOfAccountLabel4.ACC_HeadTypeID=@ACC_HeadTypeID" : "") + @"
and Inv_ItemTransaction.RowStatusID=1
and
Inv_Utilization.UtilizationDate >= @FromDate and Inv_Utilization.UtilizationDate <= @ToDate
group by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
order by Inv_Item.RawMaterialID,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text,ACC_ChartOfAccountLabel4.ExtraField1
";
DataSet ds = CommonManager.SQLExec(sql);
List <Inv_Item> items = new List <Inv_Item>();
foreach (DataTable tbl in ds.Tables)
{
foreach (DataRow dr in tbl.Rows)
{
Inv_Item newItem = new Inv_Item();
bool isFound = false;
foreach (Inv_Item inv_Item in items)
{
if (dr["RawMaterialID"].ToString() == inv_Item.Inv_ItemID.ToString())
{
isFound = true;
break;
}
}
if (!isFound)
{
newItem.Inv_ItemID = int.Parse(dr["RawMaterialID"].ToString());
newItem.ItemCode = dr["ExtraField1"].ToString();
newItem.ItemName = dr["ChartOfAccountLabel4Text"].ToString();
newItem.ExtraField1 = "0@0";
newItem.ExtraField2 = "0@0";
newItem.ExtraField3 = "0@0";
newItem.ExtraField4 = "0@0";
newItem.ExtraField5 = "0@0";
newItem.ExtraField6 = "0@0";
newItem.ExtraField7 = "0@0";
newItem.ExtraField8 = "0@0";
newItem.ExtraField9 = "0@0";
newItem.ExtraField10 = "0@0";
newItem.ExtraFieldQuantity1 = 0;
newItem.ExtraFieldQuantity2 = 0;
newItem.ExtraFieldQuantity3 = 0;
newItem.ExtraFieldQuantity4 = 0;
newItem.ExtraFieldQuantity5 = 0;
newItem.IssueReturedQuantity = 0;
newItem.LostQuantity = 0;
newItem.PurchasedQuantity = 0;
newItem.PurchasedQuantityPrice = 0;
newItem.QualityValue = 0;
items.Add(newItem);
}
}
}
sql = "";
foreach (Inv_Item inv_Item in items)
{
sql += @"select top 1 Inv_QuantityUnit.QuantityUnitName,'" + inv_Item.Inv_ItemID.ToString() + @"' as RawMetarialID from Inv_Item
inner join Inv_QuantityUnit on Inv_QuantityUnit.Inv_QuantityUnitID= Inv_Item.QuantityUnitID
where RawMaterialID=" + inv_Item.Inv_ItemID.ToString() + ";";
}
DataSet ds2 = CommonManager.SQLExec(sql);
for (int i = 0; i < items.Count; i++)
{
if (ds2.Tables[i].Rows[0]["RawMetarialID"].ToString() == items[i].Inv_ItemID.ToString())
{
items[i].QuantityUnitName = ds2.Tables[i].Rows[0]["QuantityUnitName"].ToString();
}
}
foreach (Inv_Item inv_Item in items)
{
//Purchase stock
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField1 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");
break;
}
}
//Purchase Current
foreach (DataRow dr in ds.Tables[1].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField2 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//purchase Adjustment Stock
foreach (DataRow dr in ds.Tables[2].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField3 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//purchase Adjustment Current
foreach (DataRow dr in ds.Tables[3].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField4 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//purchase Return Stock
foreach (DataRow dr in ds.Tables[4].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField5 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//purchase Return Current
foreach (DataRow dr in ds.Tables[5].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField6 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Issue Stock
foreach (DataRow dr in ds.Tables[6].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField7 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Issue Current
foreach (DataRow dr in ds.Tables[7].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField8 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Issue Return Stock
foreach (DataRow dr in ds.Tables[8].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField9 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Issue Return Current
foreach (DataRow dr in ds.Tables[9].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraField10 = decimal.Parse(dr["Qty"].ToString()).ToString("0.00") + "@" + decimal.Parse(dr["QtyPrice"].ToString()).ToString("0.00");;
break;
}
}
//Wastage Stock
foreach (DataRow dr in ds.Tables[10].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity1 = decimal.Parse(dr["Qty"].ToString());
inv_Item.LostQuantity = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Wastage Current
foreach (DataRow dr in ds.Tables[11].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity2 = decimal.Parse(dr["Qty"].ToString());
inv_Item.QualityValue = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Utilization Stock
foreach (DataRow dr in ds.Tables[12].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity3 = decimal.Parse(dr["Qty"].ToString());
inv_Item.UtilizedQuantity = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Utilization Current
foreach (DataRow dr in ds.Tables[13].Rows)
{
if (inv_Item.Inv_ItemID.ToString() == dr["RawMaterialID"].ToString())
{
inv_Item.ExtraFieldQuantity4 = decimal.Parse(dr["Qty"].ToString());
inv_Item.ExtraFieldQuantity5 = decimal.Parse(dr["QtyPrice"].ToString());
break;
}
}
//Opining Stock
inv_Item.PurchasedQuantity =
decimal.Parse(inv_Item.ExtraField1.Split('@')[0]) //Purchase
+
decimal.Parse(inv_Item.ExtraField3.Split('@')[0]) //Purchase Adjustment
-
decimal.Parse(inv_Item.ExtraField5.Split('@')[0]) //Purchase Return
-
decimal.Parse(inv_Item.ExtraField7.Split('@')[0]) //Issue
+
decimal.Parse(inv_Item.ExtraField9.Split('@')[0]) //Issue Return
-
inv_Item.ExtraFieldQuantity1 //Wastage
//-
//inv_Item.ExtraFieldQuantity3
; //Utilization
//Stock in hand
inv_Item.PurchasedQuantityPrice =
inv_Item.PurchasedQuantity
+
decimal.Parse(inv_Item.ExtraField2.Split('@')[0]) //Purchase
+
decimal.Parse(inv_Item.ExtraField4.Split('@')[0]) //Purchase Adjustment
-
decimal.Parse(inv_Item.ExtraField6.Split('@')[0]) //Purchase Return
-
decimal.Parse(inv_Item.ExtraField8.Split('@')[0]) //Issue
+
decimal.Parse(inv_Item.ExtraField10.Split('@')[0]) //Issue Return
-
inv_Item.ExtraFieldQuantity2 //Wastage
//-
//inv_Item.ExtraFieldQuantity4
; //Utilization
//Stock Price
inv_Item.IssueReturedQuantity =
decimal.Parse(inv_Item.ExtraField1.Split('@')[1]) //Purchase
+
decimal.Parse(inv_Item.ExtraField3.Split('@')[1]) //Purchase Adjustment
-
decimal.Parse(inv_Item.ExtraField5.Split('@')[1]) //Purchase Return
-
decimal.Parse(inv_Item.ExtraField7.Split('@')[1]) //Issue
+
decimal.Parse(inv_Item.ExtraField9.Split('@')[1]) //Issue Return
-
inv_Item.LostQuantity //Wastage
//-
//inv_Item.UtilizedQuantity //Utilization
+
decimal.Parse(inv_Item.ExtraField2.Split('@')[1]) //Purchase
+
decimal.Parse(inv_Item.ExtraField4.Split('@')[1]) //Purchase Adjustment
-
decimal.Parse(inv_Item.ExtraField6.Split('@')[1]) //Purchase Return
-
decimal.Parse(inv_Item.ExtraField8.Split('@')[1]) //Issue
+
decimal.Parse(inv_Item.ExtraField10.Split('@')[1]) //Issue Return
-
inv_Item.QualityValue //Wastage
//-
//inv_Item.ExtraFieldQuantity5 //Utilization
;
//keep on the quantity
inv_Item.ExtraField1 = inv_Item.ExtraField1.Split('@')[0];
inv_Item.ExtraField2 = inv_Item.ExtraField2.Split('@')[0];
inv_Item.ExtraField3 = inv_Item.ExtraField3.Split('@')[0];
inv_Item.ExtraField4 = inv_Item.ExtraField4.Split('@')[0];
inv_Item.ExtraField5 = inv_Item.ExtraField5.Split('@')[0];
inv_Item.ExtraField6 = inv_Item.ExtraField6.Split('@')[0];
inv_Item.ExtraField7 = inv_Item.ExtraField7.Split('@')[0];
inv_Item.ExtraField8 = inv_Item.ExtraField8.Split('@')[0];
inv_Item.ExtraField9 = inv_Item.ExtraField9.Split('@')[0];
inv_Item.ExtraField10 = inv_Item.ExtraField10.Split('@')[0];
}
decimal OpiningQuantity = 0;
decimal PurchasedQuantity = 0;
decimal PurchaseAdjustMent = 0;
decimal PurchaseReturn = 0;
decimal IssuedQuantity = 0;
decimal IssueReturedQuantity = 0;
decimal WastageQuantity = 0;
decimal UtilizedQuantity = 0;
decimal AvailableInStore = 0;
decimal StoreTotalAmount = 0;
int serialNo = 1;
string htmlTable = @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
<tr id='tableHeader'>
<td style='border-left:0px;'>S/L</td>
<td>Item Code</td>
<td>Item Name</td>
<td>Unit</td>
<td>Opining</td>
<td><a href='PurchaseReportSupplierWisePrint.aspx?RawmaterialsTypeID=" + RawmaterialsTypeID + @"&SuppliyerID=0&FromDate=" + fromDate + "&ToDate=" + toDate + "' target='_blank'>Purchase<br/>Quantity" + @"</a></td>
<td>Purchase<br/>Adjustment<br/>Quantity</td>
<td>Purchase<br/>Return<br/>Quantity</td>
<td><a href='IssueReportWorkStationWisePrint.aspx?RawmaterialsTypeID=" + RawmaterialsTypeID + @"&WorkstationID=0&FromDate=" + fromDate + "&ToDate=" + toDate + "' target='_blank'>Issue<br/>Quantity" + @"</a></td></td>
<td>Issue<br/>Return<br/>Quantity</td>
<td>Wastage<br/>Quantity</td>
<td>Utlized<br/>Quantity</td>
<td>Stock<br/>Quantity</td>
<td>Stock<br/>Amount</td>
</tr>";
foreach (Inv_Item inv_Item in items)
{
if (inv_Item.PurchasedQuantity == 0 &&
inv_Item.PurchasedQuantityPrice == 0 &&
inv_Item.ExtraField2 == "0" &&
inv_Item.ExtraField4 == "0" &&
inv_Item.ExtraField6 == "0" &&
inv_Item.ExtraField8 == "0" &&
inv_Item.ExtraField10 == "0" &&
inv_Item.ExtraFieldQuantity2 == 0 &&
inv_Item.ExtraFieldQuantity4 == 0
)
{
continue;
}
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
<td>" + inv_Item.ItemCode + @"</td>
<td>" + inv_Item.ItemName + @"</td>
<td >" + inv_Item.QuantityUnitName + @"</td>
<td style='text-align:right;'>" + inv_Item.PurchasedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + decimal.Parse(inv_Item.ExtraField2).ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + decimal.Parse(inv_Item.ExtraField4).ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + decimal.Parse(inv_Item.ExtraField6).ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + decimal.Parse(inv_Item.ExtraField8).ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + decimal.Parse(inv_Item.ExtraField10).ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.ExtraFieldQuantity2.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.ExtraFieldQuantity4.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.PurchasedQuantityPrice.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + inv_Item.IssueReturedQuantity.ToString("0,0.00") + @"</td>
</tr>";
OpiningQuantity += inv_Item.PurchasedQuantity;
PurchasedQuantity += decimal.Parse(inv_Item.ExtraField2);
PurchaseAdjustMent += decimal.Parse(inv_Item.ExtraField4);
PurchaseReturn += decimal.Parse(inv_Item.ExtraField6);
IssuedQuantity += decimal.Parse(inv_Item.ExtraField8);
IssueReturedQuantity += decimal.Parse(inv_Item.ExtraField10);
WastageQuantity += inv_Item.ExtraFieldQuantity2;
UtilizedQuantity += inv_Item.ExtraFieldQuantity4;
AvailableInStore += inv_Item.PurchasedQuantityPrice;
StoreTotalAmount += inv_Item.IssueReturedQuantity;
}
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td> </td>
<td>Total</td>
<td style='text-align:right;'>" + OpiningQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + PurchasedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + PurchaseAdjustMent.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + PurchaseReturn.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + IssuedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + IssueReturedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + WastageQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + UtilizedQuantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + AvailableInStore.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + StoreTotalAmount.ToString("0,0.00") + @"</td>
</tr></table>";
lblItemList.Text = htmlTable;
}
private List <Inv_Item> loadFromTheGrid()
{
List <Inv_Item> PurchasedItem = new List <Inv_Item>();
int serial = 1;
foreach (GridViewRow gvr in gvInv_Item.Rows)
{
Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID");
Label lblItemName = (Label)gvr.FindControl("lblItemName");
HiddenField hfRawMaterialID = (HiddenField)gvr.FindControl("hfRawMaterialID");
HiddenField hfQualityUnitID = (HiddenField)gvr.FindControl("hfQualityUnitID");
HiddenField hfQuantityUnitID = (HiddenField)gvr.FindControl("hfQuantityUnitID");
HiddenField hfExtraField3 = (HiddenField)gvr.FindControl("hfExtraField3");
HiddenField hfExtraField4 = (HiddenField)gvr.FindControl("hfExtraField4");
HiddenField hfExtraField5 = (HiddenField)gvr.FindControl("hfExtraField5");
Label lblItemCode = (Label)gvr.FindControl("lblItemCode");
Label lblQualityValue = (Label)gvr.FindControl("lblQualityValue");
Label lblQualityUnitName = (Label)gvr.FindControl("lblQualityUnitName");
Label lblPurchasedQuantity = (Label)gvr.FindControl("lblPurchasedQuantity");
Label lblQuantityUnitName = (Label)gvr.FindControl("lblQuantityUnitName");
Label lblPricePerUnit = (Label)gvr.FindControl("lblPricePerUnit");
Inv_Item inv_Item = new Inv_Item();
inv_Item.ItemName = lblItemName.Text;
inv_Item.PurchaseID = serial++;
inv_Item.ItemCode = lblItemCode.Text;
inv_Item.RawMaterialID = Int32.Parse(hfRawMaterialID.Value);
inv_Item.StoreID = 2;
inv_Item.QualityUnitID = Int32.Parse(hfQualityUnitID.Value);
inv_Item.QualityUnitName = lblQualityUnitName.Text;
inv_Item.QualityValue = Decimal.Parse(lblQualityValue.Text);
inv_Item.QuantityUnitID = Int32.Parse(hfQuantityUnitID.Value);
inv_Item.QuantityUnitName = lblQuantityUnitName.Text;
inv_Item.PricePerUnit = Decimal.Parse(lblPricePerUnit.Text);
inv_Item.PurchasedQuantity = Decimal.Parse(lblPurchasedQuantity.Text);
inv_Item.PurchasedQuantityPrice = inv_Item.PricePerUnit * inv_Item.PurchasedQuantity;
inv_Item.IssueReturedQuantity = 0;
inv_Item.UtilizedQuantity = 0;
inv_Item.LostQuantity = 0;
inv_Item.ExtraFieldQuantity1 = inv_Item.PurchasedQuantity;
inv_Item.ExtraFieldQuantity2 = 0;
inv_Item.ExtraFieldQuantity3 = 0;
inv_Item.ExtraFieldQuantity4 = 0;
inv_Item.ExtraFieldQuantity5 = 0;
inv_Item.ExtraField1 = "";
inv_Item.ExtraField2 = "";
inv_Item.ExtraField3 = hfExtraField3.Value;
inv_Item.ExtraField4 = hfExtraField4.Value;
inv_Item.ExtraField5 = hfExtraField5.Value;
inv_Item.ExtraField6 = "";
inv_Item.ExtraField7 = "";
inv_Item.ExtraField8 = "";
inv_Item.ExtraField9 = "";
inv_Item.ExtraField10 = "";
inv_Item.AddedBy = getLogin().LoginID;
inv_Item.AddedDate = DateTime.Now;
inv_Item.UpdatedBy = getLogin().LoginID;
inv_Item.UpdatedDate = DateTime.Now;
inv_Item.RowStatusID = 1;
PurchasedItem.Add(inv_Item);
}
return(PurchasedItem);
}
