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