private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text.Trim() == string.Empty)
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Enter Product Name.");
txtName.Focus();
return;
}
decimal vPurPrice = 0;
decimal vSalePrice = 0;
Objects.Products obj = new Objects.Products();
obj.ProductID = Int64.Parse(txtID.Text);
obj.ProductName = txtName.Text.Trim();
obj.UnitID = int.Parse(cboUnit.SelectedValue.ToString());
decimal.TryParse(this.txtPurPrice.Text, out vPurPrice);
decimal.TryParse(this.txtSalePrice.Text, out vSalePrice);
obj.CostPrice = vPurPrice;
obj.SalePrice = vSalePrice;
decimal vOpQty = 0;
decimal vOpValue = 0;
decimal.TryParse(this.txtOpQty.Text, out vOpQty);
decimal.TryParse(this.txtOpValue.Text, out vOpValue);
obj.OpeningStock = vOpQty;
obj.OpeningStockValue = vOpValue;
obj.IsRawMaterial = chkRawMaterial.Checked;
if (!vOpenMode)
{
//Insert
obj.ProductID = objDAL.getNextNo();
objDAL.InsertRecord(obj);
}
else
{
// UPdate
objDAL.UpdateRecord(obj);
}
Message.ShowMessage(MyMessages.MessageType.SaveRecord);
LoadGrid();
btnClear_Click(sender, e);
}
catch (Exception exc)
{
Message.ShowMessage(MyMessages.MessageType.Error, exc.Message);
}
}
public void UpdateRecord(Objects.Products obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_ProductsUpdate";
cmd.Parameters.AddWithValue("@ProductID", obj.ProductID);
cmd.Parameters.AddWithValue("@ProductName", obj.ProductName);
cmd.Parameters.AddWithValue("@CostPrice", obj.CostPrice);
cmd.Parameters.AddWithValue("@SalePrice", obj.SalePrice);
cmd.Parameters.AddWithValue("@UnitID", obj.UnitID);
cmd.Parameters.AddWithValue("@OpeningStock", obj.OpeningStock);
cmd.Parameters.AddWithValue("@OpeningStockValue", obj.OpeningStockValue);
cmd.Parameters.AddWithValue("@IsRawMaterial", obj.IsRawMaterial);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public void UpdateRecord(Objects.Products obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_ProductsUpdate";
cmd.Parameters.AddWithValue("@ProductID", obj.ProductID);
cmd.Parameters.AddWithValue("@CompanyID", obj.CompanyID);
cmd.Parameters.AddWithValue("@GroupId", obj.GroupId);
cmd.Parameters.AddWithValue("@SubGroupId", obj.SubGroupId);
cmd.Parameters.AddWithValue("@Size", obj.Size);
cmd.Parameters.AddWithValue("@UnitId", obj.UnitId);
cmd.Parameters.AddWithValue("@ProductName", obj.ProductName);
cmd.Parameters.AddWithValue("@PurchasePrice", obj.PurchasePrice);
cmd.Parameters.AddWithValue("@SalePrice", obj.SalePrice);
cmd.Parameters.AddWithValue("@PurDiscRatio", obj.PurDiscRatio);
cmd.Parameters.AddWithValue("@SaleDiscRatio", obj.SaleDiscRatio);
cmd.Parameters.AddWithValue("@PurDiscValue", obj.PurDiscValue);
cmd.Parameters.AddWithValue("@SaleDiscValue", obj.SaleDiscValue);
cmd.Parameters.AddWithValue("@PurSTRatio", obj.PurSTRatio);
cmd.Parameters.AddWithValue("@SaleSTRatio", obj.SaleSTRatio);
cmd.Parameters.AddWithValue("@PurPackingId", obj.PurPackingId);
cmd.Parameters.AddWithValue("@SalPackingId", obj.SalPackingId);
cmd.Parameters.AddWithValue("@RetailPrice", obj.RetailPrice);
cmd.Parameters.AddWithValue("@IsValueB4Ratio", obj.IsValueB4Ratio);
cmd.Parameters.AddWithValue("@IsFTaxExempted", obj.IsFTaxExempted);
cmd.Parameters.AddWithValue("@PriceControlId", obj.PriceControlId);
cmd.Parameters.AddWithValue("@IsFTaxOnRP", obj.IsFTaxOnRP);
cmd.Parameters.AddWithValue("@UrduName", obj.UrduName);
cmd.Parameters.AddWithValue("@PurchasePrice2", obj.PurchasePrice2);
cmd.Parameters.AddWithValue("@PurchasePrice3", obj.PurchasePrice3);
cmd.Parameters.AddWithValue("@SalePrice2", obj.SalePrice2);
cmd.Parameters.AddWithValue("@SalePrice3", obj.SalePrice3);
cmd.Parameters.AddWithValue("@MinStockLevel", obj.MinStockLevel);
cmd.Parameters.AddWithValue("@MinStockPackId", obj.MinStockPackId);
cmd.Parameters.AddWithValue("@BarCode", obj.BarCode);
cmd.Parameters.AddWithValue("@ShortCode", obj.ShortCode);
cmd.Parameters.AddWithValue("@ProductWeight", obj.ProductWeight);
cmd.Parameters.AddWithValue("@LabourCharges", obj.LabourCharges);
cmd.Parameters.AddWithValue("@RPTaxRate", obj.RPTaxRate);
cmd.Parameters.AddWithValue("@ProductWeight2", obj.ProductWeight2);
cmd.Parameters.AddWithValue("@MinSalePrice", obj.MinSalePrice);
cmd.Parameters.AddWithValue("@MaxSalePrice", obj.MaxSalePrice);
cmd.Parameters.AddWithValue("@MaxStockLevel", obj.MaxStockLevel);
cmd.Parameters.AddWithValue("@ShelfName", obj.ShelfName);
cmd.Parameters.AddWithValue("@IsActive", obj.IsActive);
cmd.Parameters.AddWithValue("@ProductNameUrdu", obj.ProductNameUrdu);
cmd.Parameters.AddWithValue("@ProductNameShort", obj.ProductNameShort);
cmd.Parameters.AddWithValue("@BrandID", obj.BrandID);
cmd.Parameters.AddWithValue("@ManualCode", obj.ManualCode);
cmd.Parameters.AddWithValue("@Point", obj.Point);
cmd.Parameters.AddWithValue("@Shade", obj.Shade);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
