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