public void ExceptionLoggin(string ControllerName, string ActionName, string ErrorMessage) { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPEXCEPTIONLOGGING)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamControllerName, DbType.String, ControllerName); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamActionName, DbType.String, ActionName); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamExceptionMessage, DbType.String, ErrorMessage); DBAccessHelper.ExecuteNonQuery(objDbCommand); } }
public int DeleteUserAccount(Int64 BigIntPhoneNumber) { int Success = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPDELETEUSERACCOUNT)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, BigIntPhoneNumber); Success = DBAccessHelper.ExecuteNonQuery(objDbCommand); } return(Success); } catch (Exception ex) { ExceptionLoggin("ManagementDal", "DeleteUserAccount", ex.Message); return(0); } }
public int VerifySelectedAds(string SelectedAds) { int Success = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPVerifyAds)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdIdS, DbType.String, SelectedAds); Success = DBAccessHelper.ExecuteNonQuery(objDbCommand); } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "VerifySelectedAds", ex.Message); Success = 0; } return(Success); }
public int InsertReview(Int64 PhoneNumber, String reviewDescription) { int Success = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPInsertReview)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, PhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMReview, DbType.String, reviewDescription); Success = DBAccessHelper.ExecuteNonQuery(objDbCommand); } return(Success); } catch (Exception ex) { ExceptionLoggin("ManagementDal", "InsertReview", ex.Message); return(0); } }
public int insertContactUs(ContactUsEntity ENTITY) { int Success = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPInsertContactUs)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, ENTITY.PhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMSubject, DbType.String, ENTITY.Subject); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMDescription, DbType.String, ENTITY.Description); Success = DBAccessHelper.ExecuteNonQuery(objDbCommand); } return(Success); } catch (Exception ex) { ExceptionLoggin("ManagementDal", "insertContactUs", ex.Message); return(0); } }
public void UpdateAdDetails(AdDetailsEntity Obj) { try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPUPDATEADDETAILS)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdId, DbType.String, Obj.AdID); // DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdTitle, DbType.String, Obj.Title); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdCategory, DbType.String, Obj.Category); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamSubCategoryName, DbType.String, Obj.txtSubCategoryName); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdDescription, DbType.String, Obj.AdDescription); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPrice, DbType.String, Obj.Price); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamQuantity, DbType.String, Obj.Quantity); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamSellingUnit, DbType.String, Obj.SellingUnit); DBAccessHelper.ExecuteNonQuery(objDbCommand); } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "UpdateAdDetails", ex.Message); } }
public int SPInsertAdViewsStatistics(AdDetailsEntity Entity) { int Success = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPInsertAdViewsStatistics)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamUserId, DbType.Int32, Entity.UserID); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, Entity.MobileNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdId, DbType.Int32, Entity.AdID); Success = DBAccessHelper.ExecuteNonQuery(objDbCommand); } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "SPInsertAdViewsStatistics", ex.Message); Success = 0; } return(Success); }