public int InsertUserProfDetail(PropertyModels obj_BLL, out string sStatus)
{
string dStatus = string.Empty;
int iRowAffected = 0;
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_InsertUserProfDetail", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@FT_USERID", obj_BLL.FT_USERID);
oCommand.Parameters.AddWithValue("@FT_NAME", obj_BLL.FT_NAME);
oCommand.Parameters.AddWithValue("@FT_ADD", obj_BLL.FT_ADD);
oCommand.Parameters.AddWithValue("@FT_STATENAME", obj_BLL.FT_STATENAME);
oCommand.Parameters.AddWithValue("@FT_CITY", obj_BLL.FT_CITY);
oCommand.Parameters.AddWithValue("@FT_PIN", obj_BLL.FT_PIN);
oCommand.Parameters.AddWithValue("@FT_COUNTRY", obj_BLL.FT_COUNTRY);
oCommand.Parameters.AddWithValue("@FT_MOBILE", obj_BLL.FT_MOBILE);
oCommand.Parameters.Add("@sStatus", SqlDbType.VarChar, 10).Direction = ParameterDirection.Output;
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
dStatus = oCommand.Parameters["@sStatus"].Value.ToString();
oConnection.Close();
}
sStatus = dStatus;
return(iRowAffected);
}
public DataTable SearchProductDetail(PropertyModels obj_BLL)
{
oDataTable = new DataTable();
try
{
oBuilder = new SqlConnectionStringBuilder(_connectionString);
oConnection = new SqlConnection(oBuilder.ConnectionString);
oDataAdapter = new SqlDataAdapter("Jobs_SearchProductDetail", oConnection);
oDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
oDataAdapter.SelectCommand.Parameters.AddWithValue("@FT_FromAmt", obj_BLL.FT_FromAmt);
oDataAdapter.SelectCommand.Parameters.AddWithValue("@FT_ToAmt", obj_BLL.FT_ToAmt);
oDataAdapter.SelectCommand.Parameters.AddWithValue("@FT_NAME", obj_BLL.FT_NAME);
oDataAdapter.SelectCommand.Parameters.AddWithValue("@FT_PROD_CODE", obj_BLL.FT_PROD_CODE);
oDataAdapter.SelectCommand.Parameters.AddWithValue("@FT_CAT_ID", obj_BLL.FT_CAT_ID);
oDataAdapter.SelectCommand.Parameters.AddWithValue("@FT_SUBCAT_ID", obj_BLL.FT_SUBCAT_ID);
using (oConnection)
{
oConnection.Open();
oDataAdapter.Fill(oDataTable);
}
}
catch (Exception ex)
{
ApplicationError.LogErrors(ex);
}
return(oDataTable);
}
public int InsertShippingDetail(PropertyModels obj_BLL)
{
int iRowAffected = 0;
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_InsertShippingDetail", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@FT_USERID", obj_BLL.FT_USERID);
oCommand.Parameters.AddWithValue("@FT_NAME", obj_BLL.FT_NAME);
oCommand.Parameters.AddWithValue("@FT_ADD", obj_BLL.FT_ADD);
oCommand.Parameters.AddWithValue("@FT_STATEID", obj_BLL.FT_STATEID);
oCommand.Parameters.AddWithValue("@FT_STATENAME", obj_BLL.FT_STATENAME);
oCommand.Parameters.AddWithValue("@FT_CITY", obj_BLL.FT_CITY);
oCommand.Parameters.AddWithValue("@FT_PIN", obj_BLL.FT_PIN);
oCommand.Parameters.AddWithValue("@FT_COUNTRY", obj_BLL.FT_COUNTRY);
oCommand.Parameters.AddWithValue("@FT_MOBILE", obj_BLL.FT_MOBILE);
oCommand.Parameters.AddWithValue("@FT_TITLE", obj_BLL.FT_TITLE);
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
oConnection.Close();
}
return(iRowAffected);
}
public int InsertOrderDetail(PropertyModels obj_BLL)
{
int iRowAffected = 0;
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_InsertOrderDetail", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@FT_ORDERNO", obj_BLL.FT_ORDERNO);
oCommand.Parameters.AddWithValue("@FT_USERID", obj_BLL.FT_USERID);
oCommand.Parameters.AddWithValue("@FT_OR_DATE", obj_BLL.FT_OR_DATE);
oCommand.Parameters.AddWithValue("@FT_OR_NOOFITEMS", obj_BLL.FT_OR_NOOFITEMS);
oCommand.Parameters.AddWithValue("@FT_OR_PRICE", obj_BLL.FT_OR_PRICE);
oCommand.Parameters.AddWithValue("@FT_OR_DELIVERYDATE", obj_BLL.FT_OR_DELIVERYDATE);
oCommand.Parameters.AddWithValue("@FT_OR_DISC_COUPON", obj_BLL.FT_OR_DISC_COUPON);
oCommand.Parameters.AddWithValue("@FT_OR_DISCOUNT", obj_BLL.FT_OR_DISCOUNT);
oCommand.Parameters.AddWithValue("@FT_OR_SHIPPING_AMT", obj_BLL.FT_OR_SHIPPING_AMT);
oCommand.Parameters.AddWithValue("@FT_OR_TOT_PAYABLE", obj_BLL.FT_OR_TOT_PAYABLE);
oCommand.Parameters.AddWithValue("@FT_OR_USER_STATUS", obj_BLL.FT_OR_USER_STATUS);
oCommand.Parameters.AddWithValue("@FT_OR_STATUS", obj_BLL.FT_OR_STATUS);
oCommand.Parameters.AddWithValue("@FT_OR_RCPNT_MSG", obj_BLL.FT_OR_RCPNT_MSG);
oCommand.Parameters.AddWithValue("@FT_OR_OTHER_PREF", obj_BLL.FT_OR_OTHER_PREF);
oCommand.Parameters.AddWithValue("@FT_OR_DELIVERYTIME", obj_BLL.FT_OR_DELIVERYTIME);
oCommand.Parameters.AddWithValue("@FT_OR_TIMEFRAME", obj_BLL.FT_OR_TIMEFRAME);
oCommand.Parameters.AddWithValue("@FT_OR_WALLETSTATUS", obj_BLL.FT_OR_WALLETSTATUS);
oCommand.Parameters.AddWithValue("@FT_OR_WALLET_OPENAMT", obj_BLL.FT_OR_WALLET_OPENAMT);
oCommand.Parameters.AddWithValue("@FT_OR_WALLET_DEBITAMT", obj_BLL.FT_OR_WALLET_DEBITAMT);
oCommand.Parameters.AddWithValue("@FT_OR_WALLET_CLOSEAMT", obj_BLL.FT_OR_WALLET_CLOSEAMT);
oCommand.Parameters.AddWithValue("@FT_NAME", obj_BLL.FT_NAME);
oCommand.Parameters.AddWithValue("@FT_ADD", obj_BLL.FT_ADD);
oCommand.Parameters.AddWithValue("@FT_STATENAME", obj_BLL.FT_STATENAME);
oCommand.Parameters.AddWithValue("@FT_STATEID", obj_BLL.FT_STATEID);
oCommand.Parameters.AddWithValue("@FT_CITY", obj_BLL.FT_CITY);
oCommand.Parameters.AddWithValue("@FT_PIN", obj_BLL.FT_PIN);
oCommand.Parameters.AddWithValue("@FT_COUNTRY", obj_BLL.FT_COUNTRY);
oCommand.Parameters.AddWithValue("@FT_MOBILE", obj_BLL.FT_MOBILE);
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
oConnection.Close();
}
return(iRowAffected);
}
public int InsertCancelOrder(PropertyModels obj_BLL)
{
int iRowAffected = 0;
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_InsertCancelOrder", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@FT_USERID", obj_BLL.FT_USERID);
oCommand.Parameters.AddWithValue("@FT_ORDERID", obj_BLL.FT_ORDERID);
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
oConnection.Close();
}
return(iRowAffected);
}
public int AddAmountInWallet(PropertyModels obj_BLL)
{
int iRowAffected = 0;
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_AddAmountInWallet", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@ID", obj_BLL.ID);
oCommand.Parameters.AddWithValue("@ORDERNO", obj_BLL.FT_ORDERNO);
oCommand.Parameters.AddWithValue("@CREDIT_AMT", obj_BLL.FT_OR_WALLET_CREDITAMT);
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
oConnection.Close();
}
return(iRowAffected);
}
public int CheckLogin(PropertyModels obj_BLL, out string status)
{
int iRowAffected = 0;
string status_out = string.Empty;
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_CheckLoginUser", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@LoginId", obj_BLL.LoginId);
oCommand.Parameters.AddWithValue("@Password", obj_BLL.Password);
oCommand.Parameters.Add("@sStatus", SqlDbType.VarChar, 64).Direction = ParameterDirection.Output;
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
status_out = oCommand.Parameters["@sStatus"].Value.ToString();
oConnection.Close();
}
status = status_out;
return(iRowAffected);
}
public int InsertSignUp(PropertyModels obj_BLL, out string sStatus)
{
string dStatus = string.Empty;
int iRowAffected = 0;
try
{
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_InsertSignUp", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
//oCommand.Parameters.AddWithValue("@FT_TITLE", obj_BLL.FT_TITLE);
oCommand.Parameters.AddWithValue("@FT_NAME", obj_BLL.FT_NAME);
oCommand.Parameters.AddWithValue("@FT_ADD", obj_BLL.FT_ADD);
oCommand.Parameters.AddWithValue("@FT_CITY", obj_BLL.FT_CITY);
//oCommand.Parameters.AddWithValue("@FT_STATEID", obj_BLL.FT_STATEID);
oCommand.Parameters.AddWithValue("@FT_STATENAME", obj_BLL.FT_STATENAME);
oCommand.Parameters.AddWithValue("@FT_PIN", obj_BLL.FT_PIN);
oCommand.Parameters.AddWithValue("@FT_COUNTRY", obj_BLL.FT_COUNTRY);
oCommand.Parameters.AddWithValue("@FT_MOBILE", obj_BLL.FT_MOBILE);
//oCommand.Parameters.AddWithValue("@FT_DOB", obj_BLL.FT_DOB);
oCommand.Parameters.AddWithValue("@FT_EMAIL", obj_BLL.FT_EMAIL);
oCommand.Parameters.AddWithValue("@FT_PWD", obj_BLL.FT_PWD);
oCommand.Parameters.AddWithValue("@FT_REFBY", obj_BLL.FT_COUPONNO);
//oCommand.Parameters.AddWithValue("@FT_GENDER", obj_BLL.FT_GENDER);
oCommand.Parameters.Add("@sStatus", SqlDbType.VarChar, 10).Direction = ParameterDirection.Output;
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
dStatus = oCommand.Parameters["@sStatus"].Value.ToString();
oConnection.Close();
}
}
catch (Exception ex)
{
}
sStatus = dStatus;
return(iRowAffected);
}
public int InsertOrderHistroy(PropertyModels obj_BLL, out string status)
{
int iRowAffected = 0;
string status_out = string.Empty;
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("Jobs_InsertOrderHistroy", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@FT_ORDERNO", obj_BLL.FT_ORDERNO);
oCommand.Parameters.AddWithValue("@FT_USERID", obj_BLL.FT_USERID);
oCommand.Parameters.AddWithValue("@FT_DEBITAMT", obj_BLL.FT_OR_WALLET_DEBITAMT);
oCommand.Parameters.Add("@sStatus", SqlDbType.VarChar, 10).Direction = ParameterDirection.Output;
using (oConnection)
{
oConnection.Open();
iRowAffected = oCommand.ExecuteNonQuery();
status_out = oCommand.Parameters["@sStatus"].Value.ToString();
oConnection.Close();
}
status = status_out;
return(iRowAffected);
}
public int InsertCancelOrder(PropertyModels _objProperty)
{
return(oCommonDAL.InsertCancelOrder(_objProperty));
}
public int InsertOrderLogin(PropertyModels _objProperty)
{
return(oCommonDAL.InsertOrderLogin(_objProperty));
}
public int InsertSuccessOrderDisc(PropertyModels _objProperty)
{
return(oCommonDAL.InsertSuccessOrderDisc(_objProperty));
}
public int InsertSignUp(PropertyModels _objProperty, out string sStatus)
{
return(oCommonDAL.InsertSignUp(_objProperty, out sStatus));
}
public int InsertUpdateProfile(PropertyModels _objProperty, out string sStatus)
{
return(oCommonDAL.InsertUpdateProfile(_objProperty, out sStatus));
}
public DataTable SearchProductDetail(PropertyModels _objProperty)
{
return(oCommonDAL.SearchProductDetail(_objProperty));
}
public int CheckLogin(PropertyModels _objProperty, out string status)
{
return(oCommonDAL.CheckLogin(_objProperty, out status));
}
public int InsertUserProfDetail(PropertyModels _objProperty, out string sStatus)
{
return(oCommonDAL.InsertUserProfDetail(_objProperty, out sStatus));
}
public int AddAmountInWallet(PropertyModels _objProperty)
{
return(oCommonDAL.AddAmountInWallet(_objProperty));
}
public int InsertOrderDetail(PropertyModels _objProperty)
{
return(oCommonDAL.InsertOrderDetail(_objProperty));
}
public int InsertOrderHistroy(PropertyModels _objProperty, out string status)
{
return(oCommonDAL.InsertOrderHistroy(_objProperty, out status));
}
public int InsertShippingDetail(PropertyModels _objProperty)
{
return(oCommonDAL.InsertShippingDetail(_objProperty));
}
