public int InsertAdPostByAdmin(AdDetailsEntity Obj) { int AddId = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPAdPostByAdmin)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdCategory, DbType.String, Obj.Category); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdDescription, DbType.String, Obj.AdDescription); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamSubCategoryName, DbType.String, Obj.txtSubCategoryName); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPrice, DbType.Int32, Obj.Price); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamQuantity, DbType.Int32, Obj.Quantity); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamSellingUnit, DbType.String, Obj.SellingUnit); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.String, Obj.MobileNumber); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { AddId = Convert.ToInt32(dr[DataAccessConstants.ParamAdId]); } } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "InsertAddPostDetails", ex.Message); return(0); } return(AddId); }
public int UploadImage(AdDetailsEntity Obj) { int AddId = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPUPLOADIMAGE)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMPHOTO, DbType.Binary, Obj.Image); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdId, DbType.Int32, Obj.AdID); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamUserId, DbType.Int32, Obj.UserID); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { AddId = Convert.ToInt32(dr[DataAccessConstants.ParamAdId]); } } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "UploadImage", ex.Message); return(0); } return(AddId); }
public UserDetailsEntity VerifyMobileNumber(UserDetailsEntity Obj) { UserDetailsEntity Entity = new UserDetailsEntity(); try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPVERIFYMOBILENUMBER)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.String, Obj.BigIntPhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMOTP, DbType.String, Obj.OTP); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { Entity.txtName = Convert.ToString(dr[DataAccessConstants.ParamtName]); Entity.intUserId = Convert.ToInt32(dr[DataAccessConstants.ParamUserId]); Entity.BigIntPhoneNumber = Convert.ToInt64(dr[DataAccessConstants.ParamPhoneNumber]); Entity.txtPassword = Convert.ToString(dr[DataAccessConstants.ParamPasswordd]); } } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "VerifyMobileNumber", ex.Message); return(null); } return(Entity); }
public int UPDATEOTP(UserDetailsEntity Obj) { int OTP = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPUPDATEOTP)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.String, Obj.BigIntPhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMOTP, DbType.String, Obj.OTP); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { OTP = Convert.ToInt32(dr[DataAccessConstants.PARAMOTP]); } string URL = "https://2factor.in/API/V1/a2cbd769-9ef3-11e8-a895-0200cd936042/SMS/" + Obj.BigIntPhoneNumber + "/" + Obj.OTP + "/RaiteRajuOTP"; HttpWebRequest request = WebRequest.Create(URL) as HttpWebRequest; //optional HttpWebResponse response = request.GetResponse() as HttpWebResponse; Stream stream = response.GetResponseStream(); } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "UPDATEOTP", ex.Message); } return(OTP); }
public int UpdatePassword(UserDetailsEntity Obj) { int UserID = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPUPDAGEUSERDETAILS)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamUserId, DbType.Int32, Obj.intUserId); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, Obj.BigIntPhoneNumber); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { UserID = Convert.ToInt32(dr[DataAccessConstants.ParamUserId]); } } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "UpdatePassword", ex.Message); } return(UserID); }
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 void DeleteUserAd(int AdId) { try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPDELETEUSERAD)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamAdId, DbType.Int32, AdId); DBAccessHelper.ExecuteScalar(objDbCommand); } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "DeleteUserAd", ex.Message); } }
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 int InsertAddUserDetails(UserDetailsEntity Obj) { int UserID = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPINSERTUSERDETAILS)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamtName, DbType.String, Obj.txtName); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, Obj.BigIntPhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamState, DbType.String, Obj.txtState); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamDistrict, DbType.String, Obj.txtDistrict); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamMandal, DbType.String, Obj.txtMandal); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.Paramvillage, DbType.String, Obj.txtvillage); // DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamMailId, DbType.String, Obj.txtMailId); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPasswordd, DbType.String, Obj.txtPassword); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMOTP, DbType.Int32, Obj.OTP); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { UserID = Convert.ToInt32(dr[DataAccessConstants.ParamUserId]); } if (Obj.KeyForUserSettings != "ADMIN") { string URL = "https://2factor.in/API/V1/a2cbd769-9ef3-11e8-a895-0200cd936042/SMS/" + Obj.BigIntPhoneNumber + "/" + Obj.OTP + "/RaiteRajuOTP"; HttpWebRequest request = WebRequest.Create(URL) as HttpWebRequest; //optional HttpWebResponse response = request.GetResponse() as HttpWebResponse; Stream stream = response.GetResponseStream(); } } return(UserID); } catch (Exception ex) { ExceptionLoggin("ManagementDal", "InsertAddUserDetails", 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); }