public DataSet SmartzSave_RegisterLogUser(RvUserRegistrationInfo objRvUserRegInfo)
{
bool returnValue = false;
string spNameString = string.Empty;
DataSet dsUserInfo = new DataSet();
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME2);
spNameString = "USP_SmartzSaveRVRegisterLog";
DbCommand dbCommand = null;
try
{
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@Name", System.Data.DbType.String, objRvUserRegInfo.Name);
dbDatabase.AddInParameter(dbCommand, "@UserName", System.Data.DbType.String, objRvUserRegInfo.UserName);
dbDatabase.AddInParameter(dbCommand, "@Pwd", System.Data.DbType.String, objRvUserRegInfo.Pwd);
dbDatabase.AddInParameter(dbCommand, "@PhoneNumber", System.Data.DbType.String, objRvUserRegInfo.PhoneNumber);
dbDatabase.AddInParameter(dbCommand, "@isActive", System.Data.DbType.Int32, objRvUserRegInfo.IsActive);
dbDatabase.AddInParameter(dbCommand, "@CouponCode", System.Data.DbType.String, objRvUserRegInfo.CouponCode);
dbDatabase.AddInParameter(dbCommand, "@ReferCode", System.Data.DbType.String, objRvUserRegInfo.ReferCode);
dbDatabase.AddInParameter(dbCommand, "@PackageID", System.Data.DbType.Int32, objRvUserRegInfo.PackageID);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objRvUserRegInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objRvUserRegInfo.City);
dbDatabase.AddInParameter(dbCommand, "@Address", System.Data.DbType.String, objRvUserRegInfo.Address);
dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objRvUserRegInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@BusinessName", System.Data.DbType.String, objRvUserRegInfo.BusinessName);
dbDatabase.AddInParameter(dbCommand, "@AltEmail", System.Data.DbType.String, objRvUserRegInfo.AltEmail);
dbDatabase.AddInParameter(dbCommand, "@AltPhone", System.Data.DbType.String, objRvUserRegInfo.AltPhone);
dbDatabase.AddInParameter(dbCommand, "@SaleAgentID", System.Data.DbType.Int32, objRvUserRegInfo.SaleAgentID);
dbDatabase.AddInParameter(dbCommand, "@VerifierID", System.Data.DbType.Int32, objRvUserRegInfo.VerifierID);
dsUserInfo = dbDatabase.ExecuteDataSet(dbCommand);
//blnSuccess = objUserLog.SaveUserLog(UserLogInfo, ref lngReturn, "");
return dsUserInfo;
}
catch (Exception ex)
{
throw ex;
}
}
public bool SmartzUpdateRegUserDetails(RvUserRegistrationInfo objUserRegInfo, int TranBy)
{
try
{
bool bnew = false;
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME2);
spNameString = "USP_SmartzUpdateRegUserDetails";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@UId", System.Data.DbType.Int32, objUserRegInfo.UId);
dbDatabase.AddInParameter(dbCommand, "@Name", System.Data.DbType.String, objUserRegInfo.Name);
dbDatabase.AddInParameter(dbCommand, "@PhoneNumber", System.Data.DbType.String, objUserRegInfo.PhoneNumber);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objUserRegInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objUserRegInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@Address", System.Data.DbType.String, objUserRegInfo.Address);
dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objUserRegInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@UserName", System.Data.DbType.String, objUserRegInfo.UserName);
dbDatabase.AddInParameter(dbCommand, "@Pwd", System.Data.DbType.String, objUserRegInfo.Pwd);
dbDatabase.AddInParameter(dbCommand, "@ReferCode", System.Data.DbType.String, objUserRegInfo.ReferCode);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dbDatabase.AddInParameter(dbCommand, "@BusinessName", System.Data.DbType.String, objUserRegInfo.BusinessName);
dbDatabase.AddInParameter(dbCommand, "@AltEmail", System.Data.DbType.String, objUserRegInfo.AltEmail);
dbDatabase.AddInParameter(dbCommand, "@AltPhone", System.Data.DbType.String, objUserRegInfo.AltPhone);
dbDatabase.ExecuteDataSet(dbCommand);
bnew = true;
return bnew;
}
catch (Exception ex)
{
throw ex;
}
}