public DataTable GetCountries()
{
ProcedureExecute proc = new ProcedureExecute("prcBidder");
proc.AddVarcharPara("@Action", 100, "GetCountries");
return(proc.GetTable());
}
public DataTable GetProductCategoryLevel1()
{
ProcedureExecute proc = new ProcedureExecute("prcTimedProductLot");
proc.AddVarcharPara("@Action", 100, "GetCategoryLevel1");
return(proc.GetTable());
}
public DataSet GetLotListByAuctionID(int AuctionId)
{
ProcedureExecute proc = new ProcedureExecute("prcAuction");
proc.AddVarcharPara("@Action", 100, "GetLotListByAuctionID");
proc.AddIntegerPara("@AuctionId", AuctionId);
return(proc.GetDataSet());
}
public DataTable GetAuctionWithType(int AuctionTypeId)
{
ProcedureExecute proc = new ProcedureExecute("prcAuction");
proc.AddVarcharPara("@Action", 100, "GetAuctionWithType");
proc.AddIntegerPara("@AuctionTypeId", AuctionTypeId);
return(proc.GetTable());
}
public DataTable GetProductCategoryLevel3(int parentCategoryIdLevel2)
{
ProcedureExecute proc = new ProcedureExecute("prcTimedProductLot");
proc.AddVarcharPara("@Action", 100, "GetCategoryLevel3");
proc.AddIntegerPara("@ParentCategoryIdLevel2", parentCategoryIdLevel2);
return(proc.GetTable());
}
public DataTable SellerAccountDetails(int SellerId)
{
ProcedureExecute proc = new ProcedureExecute("prcBidder");
proc.AddVarcharPara("@Action", 100, "SellerAccountDetails");
proc.AddIntegerPara("@SellerId", SellerId);
return(proc.GetTable());
}
public DataTable GetTimeZonesFromCountry(int CountryId)
{
ProcedureExecute proc = new ProcedureExecute("prcBidder");
proc.AddVarcharPara("@Action", 100, "GetTimeZonesFromCountry");
proc.AddIntegerPara("@CountryId", CountryId);
return(proc.GetTable());
}
public bool Save(DealEL DealEL, out string Responcetxt)
{
ProcedureExecute proc;
bool Res = false; string strError = string.Empty;
try
{
using (proc = new ProcedureExecute("prcDeal"))
{
proc.AddVarcharPara("@Action", 100, "Save");
proc.AddVarcharPara("@ProductUsed", 200, DealEL.ProductUsed);
proc.AddIntegerPara("@CategoryId", DealEL.CategoryId);
proc.AddBooleanPara("@IsBranded", DealEL.IsBranded);
proc.AddVarcharPara("@Title", 200, DealEL.Title);
proc.AddVarcharPara("@SKU", 200, DealEL.SKU);
proc.AddVarcharPara("@Description", 200, DealEL.Description);
proc.AddVarcharPara("@Question", 200, DealEL.Question);
proc.AddVarcharPara("@OriginalPrice", 200, DealEL.OriginalPrice);
proc.AddVarcharPara("@DealPrice", 200, DealEL.DealPrice);
proc.AddDateTimePara("@DealDate", DealEL.DealDate);
proc.AddVarcharPara("@DealTime", 200, DealEL.DealTime);
proc.AddVarcharPara("@StartingBid", 200, DealEL.StartingBid);
proc.AddVarcharPara("@ShipWithin", 200, DealEL.ShipWithin);
proc.AddVarcharPara("@DeliveryTime", 200, DealEL.DeliveryTime);
proc.AddVarcharPara("@ShipCountry", 200, DealEL.ShipCountry);
proc.AddVarcharPara("@ShippingPrice", 200, DealEL.ShippingPrice);
proc.AddBooleanPara("@IsFreeShipping", DealEL.IsFreeShipping);
proc.AddBooleanPara("@IsShippedEverywhere", DealEL.IsShippedEverywhere);
proc.AddVarcharPara("@Images", 800, DealEL.images);
proc.AddNVarcharPara("@ReturnValue", 500, DealEL.ReturnValue, QueryParameterDirection.Output);
int i = proc.RunActionQuery();
if (i > 0)
{
Res = true;
DealEL.DealId = 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;
}
}
public DataTable GetAuction(string userType, int userId)
{
ProcedureExecute proc = new ProcedureExecute("prcTimedProductLot");
proc.AddVarcharPara("@Action", 100, "GetAuction");
proc.AddVarcharPara("@UserType", 10, userType);
proc.AddIntegerPara("@UserId", userId);
return(proc.GetTable());
}
public DataTable EmailCheck(string Email, string UserType)
{
ProcedureExecute proc = new ProcedureExecute("prcBidder");
proc.AddVarcharPara("@Action", 100, "EmailCheck");
proc.AddVarcharPara("@Email", 200, Email);
proc.AddVarcharPara("@UserType", 200, UserType);
return(proc.GetTable());
}
public DataTable GetLoginUser(string Email, string Password, string UserType)
{
ProcedureExecute proc = new ProcedureExecute("prcBidder");
proc.AddVarcharPara("@Action", 100, "BidderSellerLogin");
proc.AddVarcharPara("@Email", 200, Email);
proc.AddVarcharPara("@Password", 200, Password);
proc.AddVarcharPara("@UserType", 200, UserType);
return(proc.GetTable());
}
public bool UpdateSellerAccount(BidderEL objBidderEL, out string Responcetxt)
{
ProcedureExecute proc;
bool Res = false; string strError = string.Empty;
try
{
using (proc = new ProcedureExecute("prcBidder"))
{
proc.AddVarcharPara("@Action", 100, "UpdateSellerAccount");
proc.AddVarcharPara("@PreferredName", 200, objBidderEL.PreferredName);
proc.AddVarcharPara("@Telephone", 50, objBidderEL.Telephone);
proc.AddVarcharPara("@Country", 50, objBidderEL.Country);
proc.AddVarcharPara("@TimeZone", 50, objBidderEL.TimeZone);
proc.AddIntegerPara("@SellerId", objBidderEL.BidderId);
proc.AddNVarcharPara("@ReturnValue", 500, objBidderEL.ReturnValue, QueryParameterDirection.Output);
int i = proc.RunActionQuery();
if (i > 0)
{
Res = true;
//objBidderEL.BidderId = Convert.ToInt32(proc.GetParaValue("@ReturnValue"));
strError = "Successfully Updated.";
}
else
{
strError = Convert.ToString(proc.GetParaValue("@ReturnValue"));
}
Responcetxt = strError;
return(Res);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
proc = null;
}
}
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;
}
}
public bool BidderSignUp(BidderEL objBidderEL, out string Responcetxt)
{
//BidderCardDetailEL BidderCardDetailEL=new BidderCardDetailEL();
ProcedureExecute proc;
bool Res = false; string strError = string.Empty;
try
{
using (proc = new ProcedureExecute("prcBidder"))
{
proc.AddVarcharPara("@Action", 100, "BidderSellerSignUp");
proc.AddVarcharPara("@Email", 200, objBidderEL.Email);
proc.AddVarcharPara("@Password", 200, objBidderEL.Password);
proc.AddVarcharPara("@FirstName", 200, objBidderEL.FirstName);
proc.AddVarcharPara("@LastName", 200, objBidderEL.LastName);
proc.AddVarcharPara("@Telephone", 200, objBidderEL.Telephone);
proc.AddVarcharPara("@Address", 200, objBidderEL.Address);
proc.AddVarcharPara("@City", 200, objBidderEL.City);
proc.AddVarcharPara("@Country", 200, objBidderEL.Country);
proc.AddVarcharPara("@PinCode", 200, objBidderEL.PinCode);
proc.AddVarcharPara("@UserType", 200, objBidderEL.UserType);
proc.AddNVarcharPara("@ReturnValue", 500, objBidderEL.ReturnValue, QueryParameterDirection.Output);
proc.AddVarcharPara("@CardType", 200, objBidderEL.CardType);
proc.AddVarcharPara("@CardNo", 200, objBidderEL.CardNo);
proc.AddIntegerPara("@CardStartMonth", objBidderEL.CardStartMonth);
proc.AddIntegerPara("@CardStartYear", objBidderEL.CardStartYear);
proc.AddIntegerPara("@CardExpiryMonth", objBidderEL.CardExpiryMonth);
proc.AddIntegerPara("@CardExpiryYear", objBidderEL.CardExpiryYear);
proc.AddVarcharPara("@SecurityCode", 200, objBidderEL.SecurityCode);
proc.AddVarcharPara("@CardNickName", 200, objBidderEL.CardNickName);
proc.AddVarcharPara("@CardHolderName", 200, objBidderEL.CardHolderName);
proc.AddVarcharPara("@CardBillingAddress1", 200, objBidderEL.CardBillingAddress1);
proc.AddVarcharPara("@CardBillingAddress2", 200, objBidderEL.CardBillingAddress2);
proc.AddVarcharPara("@CardBillingCity", 200, objBidderEL.City);
proc.AddVarcharPara("@CardBillingCountry", 200, objBidderEL.Country);
proc.AddVarcharPara("@CardBillingState", 200, objBidderEL.CardBillingState);
proc.AddVarcharPara("@CardBillingZipCode", 200, objBidderEL.CardBillingZipCode);
proc.AddVarcharPara("@CreatedBy", 200, objBidderEL.CreatedBy);
proc.AddIntegerPara("@UpdatedBy", objBidderEL.UpdatedBy);
proc.AddVarcharPara("@IpAddress", 200, objBidderEL.IpAddress);
int i = proc.RunActionQuery();
if (i > 0)
{
Res = true;
objBidderEL.BidderId = Convert.ToInt32(proc.GetParaValue("@ReturnValue"));
strError = "Successfully Registered.";
}
else
{
strError = Convert.ToString(proc.GetParaValue("@ReturnValue"));
}
Responcetxt = strError;
return(Res);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
proc = null;
}
}
