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