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)); }