public bool Save(TimedProductLotEL TimedProductLotEL, out string Responcetxt)
{
ProcedureExecute proc;
bool Res = false; string strError = string.Empty;
try
{
using (proc = new ProcedureExecute("prcTimedProductLot"))
{
proc.AddVarcharPara("@Action", 100, "Save");
proc.AddVarcharPara("@ProductUsed", 200, TimedProductLotEL.ProductUsed);
proc.AddIntegerPara("@CategoryId", TimedProductLotEL.CategoryId);
proc.AddIntegerPara("@AuctionId", TimedProductLotEL.AuctionId);
proc.AddBooleanPara("@IsBranded", TimedProductLotEL.IsBranded);
proc.AddVarcharPara("@Title", 200, TimedProductLotEL.Title);
proc.AddVarcharPara("@SKU", 200, TimedProductLotEL.SKU);
proc.AddVarcharPara("@Description", 200, TimedProductLotEL.Description);
proc.AddVarcharPara("@Question", 200, TimedProductLotEL.Question);
proc.AddIntegerPara("@Quantity", TimedProductLotEL.Quantity);
proc.AddVarcharPara("@CostBasis", 200, TimedProductLotEL.CostBasis);
proc.AddVarcharPara("@RetailPrice", 200, TimedProductLotEL.RetailPrice);
proc.AddVarcharPara("@BuyPrice", 200, TimedProductLotEL.BuyPrice);
proc.AddVarcharPara("@StartingBid", 200, TimedProductLotEL.StartingBid);
proc.AddVarcharPara("@ShipWithin", 200, TimedProductLotEL.ShipWithin);
proc.AddVarcharPara("@DeliveryTime", 200, TimedProductLotEL.DeliveryTime);
proc.AddVarcharPara("@ShipCountry", 200, TimedProductLotEL.ShipCountry);
proc.AddVarcharPara("@ShippingPrice", 200, TimedProductLotEL.ShippingPrice);
proc.AddBooleanPara("@IsFreeShipping", TimedProductLotEL.IsFreeShipping);
proc.AddBooleanPara("@IsShippedEverywhere", TimedProductLotEL.IsShippedEverywhere);
proc.AddVarcharPara("@Images", 800, TimedProductLotEL.images);
proc.AddNVarcharPara("@ReturnValue", 500, TimedProductLotEL.ReturnValue, QueryParameterDirection.Output);
proc.AddVarcharPara("@LowEstimatePrice", 200, TimedProductLotEL.LowEstimatePrice);
proc.AddVarcharPara("@HighEstimatePrice", 200, TimedProductLotEL.HighEstimatePrice);
proc.AddVarcharPara("@MaximumReserveValue", 200, TimedProductLotEL.MaximumReserveValue);
proc.AddBooleanPara("@IsSold", TimedProductLotEL.IsSold);
proc.AddIntegerPara("@BidderId", TimedProductLotEL.BidderId);
int i = proc.RunActionQuery();
if (i > 0)
{
Res = true;
TimedProductLotEL.ProductLotId = Convert.ToInt32(proc.GetParaValue("@ReturnValue"));
strError = "Item added successfully.";
}
else
{
strError = Convert.ToString(proc.GetParaValue("@ReturnValue"));
}
Responcetxt = strError;
return(Res);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
proc = null;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
TimedProductLotBL objTimedProductLotBL = new TimedProductLotBL();
TimedProductLotEL objTimedProductLotEL = new TimedProductLotEL();
string Responsetxt = string.Empty;
string productimages = Request["hdnimagefiles"];
objTimedProductLotEL.ProductUsed = ItemUsed.SelectedItem.ToString();
if (!categotyLevel2.Visible)
{
objTimedProductLotEL.CategoryId = Convert.ToInt32(categotyLevel1.SelectedValue);
}
else
{
if (categotyLevel3.Visible)
{
objTimedProductLotEL.CategoryId = Convert.ToInt32(categotyLevel3.SelectedValue);
}
else
{
objTimedProductLotEL.CategoryId = Convert.ToInt32(categotyLevel2.SelectedValue);
}
}
objTimedProductLotEL.AuctionId = Convert.ToInt32(auction.SelectedValue);
objTimedProductLotEL.IsBranded = rdbYes.Checked;
objTimedProductLotEL.Title = txtTitle.Text;
objTimedProductLotEL.SKU = txtSKU.Text;
objTimedProductLotEL.Description = txtDesc.Text;
objTimedProductLotEL.Question = txtQuestion.Text;
objTimedProductLotEL.Quantity = Convert.ToInt32(txtQuantity.Text);
objTimedProductLotEL.CostBasis = txtCost.Text;
objTimedProductLotEL.RetailPrice = txtRetail.Text;
objTimedProductLotEL.BuyPrice = txtBuy.Text;
objTimedProductLotEL.StartingBid = txtStartBid.Text;
objTimedProductLotEL.ShipCountry = ddlCountry.Text;
objTimedProductLotEL.ShipWithin = ddlShipWithin.Text;
objTimedProductLotEL.DeliveryTime = ddlTimeTake.Text;
objTimedProductLotEL.IsFreeShipping = chkFreeShipping.Checked;
objTimedProductLotEL.ShippingPrice = ddlPrice.Text;
objTimedProductLotEL.IsShippedEverywhere = chkShip.Checked;
objTimedProductLotEL.LowEstimatePrice = lowEstimatePrice.Text;
objTimedProductLotEL.HighEstimatePrice = highEstimatePrice.Text;
objTimedProductLotEL.MaximumReserveValue = maximumReserveValue.Text;
objTimedProductLotEL.BidderId = 0;
objTimedProductLotEL.IsSold = false;
objTimedProductLotEL.images = productimages;
if (objTimedProductLotBL.Save(objTimedProductLotEL, out Responsetxt))
{
rdbYes.Checked = false;
txtTitle.Text = "";
txtSKU.Text = "";
txtDesc.Text = "";
txtQuestion.Text = "";
txtQuantity.Text = "";
txtCost.Text = "";
txtRetail.Text = "";
txtBuy.Text = "";
txtStartBid.Text = "";
ddlCountry.Text = "";
ddlShipWithin.Text = "";
ddlTimeTake.Text = "";
chkFreeShipping.Checked = false;
ddlPrice.Text = "";
chkShip.Checked = false;
lowEstimatePrice.Text = "";
highEstimatePrice.Text = "";
maximumReserveValue.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ScriptRegistration", "alert('" + Responsetxt + "');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ScriptRegistration", "alert('" + Responsetxt + "');", true);
}
}
}