public List<UserRegistrationInfo> UpdateUserRegistration(string name,string address,string city,string stateID,string zip,string phone,string UID,
string businessName, string altEmail, string altPhone, string AuthenticationID, string CustomerID, string SessionID)
{
MobileBL objUserRegBL = new MobileBL();
var obj =new List<UserRegistrationInfo>();
MobileBL objMobileBL = new MobileBL();
if (CustomerID.Trim() != "")
{
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("UpdateUserRegistration", CustomerID, AuthenticationID,UID);
}
bool bnew = objMobileBL.CheckMobileAuthorizeUSer(SessionID, Convert.ToInt32(UID));
if (bnew)
{
try
{
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
UserRegistrationInfo objUserInfo = new UserRegistrationInfo();
objUserInfo.Name = GeneralFunc.ToProper(name).Trim();
objUserInfo.Address = GeneralFunc.ToProper(address).Trim();
objUserInfo.City = GeneralFunc.ToProper(city).Trim();
objUserInfo.StateID = Convert.ToInt32(stateID);
if (zip.Length == 4)
{
objUserInfo.Zip = "0" + zip;
}
else
{
objUserInfo.Zip = zip;
}
objUserInfo.PhoneNumber = phone;
objUserInfo.UId = Convert.ToInt32(UID);
objUserInfo.BusinessName = businessName;
objUserInfo.AltEmail = altEmail;
objUserInfo.AltPhone = altPhone;
DataSet dsCarDetailsInfo = new DataSet();
dsCarDetailsInfo = objUserRegBL.USP_UpdateRegUserDetails(objUserInfo);
if (dsCarDetailsInfo.Tables.Count > 0)
{
if (dsCarDetailsInfo.Tables[0].Rows.Count > 0)
{
UserRegistrationInfo objInfo = new UserRegistrationInfo();
objInfo.AASuccess = "Success";
objInfo.Address = dsCarDetailsInfo.Tables[0].Rows[0]["Address"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["Address"].ToString();
objInfo.AltEmail = dsCarDetailsInfo.Tables[0].Rows[0]["AltEmail"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["AltEmail"].ToString();
objInfo.AltPhone = dsCarDetailsInfo.Tables[0].Rows[0]["AltPhone"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["AltPhone"].ToString();
objInfo.BusinessName = dsCarDetailsInfo.Tables[0].Rows[0]["BusinessName"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["BusinessName"].ToString();
objInfo.City = dsCarDetailsInfo.Tables[0].Rows[0]["City"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["City"].ToString();
objInfo.CouponCode = dsCarDetailsInfo.Tables[0].Rows[0]["CouponCode"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["CouponCode"].ToString();
objInfo.CreatedDate = dsCarDetailsInfo.Tables[0].Rows[0]["CreatedDate"].ToString() == "" ? Convert.ToDateTime("1/1/1990") : Convert.ToDateTime(dsCarDetailsInfo.Tables[0].Rows[0]["CreatedDate"].ToString());
objInfo.Name = dsCarDetailsInfo.Tables[0].Rows[0]["Name"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["Name"].ToString();
objInfo.PhoneNumber = dsCarDetailsInfo.Tables[0].Rows[0]["PhoneNumber"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["PhoneNumber"].ToString();
objInfo.SellerID = dsCarDetailsInfo.Tables[0].Rows[0]["sellerID"].ToString() == "" ? 0 : Convert.ToInt32(dsCarDetailsInfo.Tables[0].Rows[0]["sellerID"].ToString());
objInfo.StateID = dsCarDetailsInfo.Tables[0].Rows[0]["StateID"].ToString() == "" ? 0 : Convert.ToInt32(dsCarDetailsInfo.Tables[0].Rows[0]["StateID"].ToString());
objInfo.StateName = dsCarDetailsInfo.Tables[0].Rows[0]["State_Code"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["State_Code"].ToString();
objInfo.UId = dsCarDetailsInfo.Tables[0].Rows[0]["UId"].ToString() == "" ? 0 : Convert.ToInt32(dsCarDetailsInfo.Tables[0].Rows[0]["UId"].ToString());
objInfo.UserName = dsCarDetailsInfo.Tables[0].Rows[0]["UserName"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["UserName"].ToString();
objInfo.Zip = dsCarDetailsInfo.Tables[0].Rows[0]["Zip"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["Zip"].ToString();
obj.Add(objInfo);
}
}
}
}
catch (Exception ex)
{
}
}
else
{
UserRegistrationInfo objUserInfo = new UserRegistrationInfo();
objUserInfo.AASuccess = "Session timed out";
obj.Add(objUserInfo);
}
return obj;
}
public DataSet SaveSaleStatusDataForTransfers(UserRegistrationInfo objUserRegInfo, int SaleAgentID, int PackageID, int YearOfMake, int MakeModelID, int BodyTypeID, int VehicleConditionID, string DriveTrain, string Price, string Mileage, string ExteriorColor, string InteriorColor, string Transmission,
string NumberOfDoors, string VIN, string NumberOfCylinder, int FuelTypeID, string Description, string ConditionDescription, string Title, string state, string Ip, string SaleNotes, int LeadStatus, string LastName, int SourceOfPhotosID, int SourceOfDescriptionID,
int CarID, int UId, int UserPackID, int sellerID, int PostingID, int DispositionID, int EmailExists)
{
try
{
bool bnew = false;
DataSet ds = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME4);
spNameString = "USP_SaveSaleStatusDataForTransfers";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@Name", System.Data.DbType.String, objUserRegInfo.Name);
dbDatabase.AddInParameter(dbCommand, "@UserName", System.Data.DbType.String, objUserRegInfo.UserName);
dbDatabase.AddInParameter(dbCommand, "@PhoneNumber", System.Data.DbType.String, objUserRegInfo.PhoneNumber);
dbDatabase.AddInParameter(dbCommand, "@Address", System.Data.DbType.String, objUserRegInfo.Address);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objUserRegInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objUserRegInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objUserRegInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@SaleAgentID", System.Data.DbType.Int32, SaleAgentID);
dbDatabase.AddInParameter(dbCommand, "@PackageID", System.Data.DbType.Int32, PackageID);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, MakeModelID);
dbDatabase.AddInParameter(dbCommand, "@BodyTypeID", System.Data.DbType.Int32, BodyTypeID);
dbDatabase.AddInParameter(dbCommand, "@VehicleConditionID", System.Data.DbType.Int32, VehicleConditionID);
dbDatabase.AddInParameter(dbCommand, "@DriveTrain", System.Data.DbType.String, DriveTrain);
dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, Price);
dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, ExteriorColor);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, Transmission);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, NumberOfDoors);
dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", System.Data.DbType.String, NumberOfCylinder);
dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, FuelTypeID);
dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, Description);
dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, ConditionDescription);
dbDatabase.AddInParameter(dbCommand, "@Title", System.Data.DbType.String, Title);
dbDatabase.AddInParameter(dbCommand, "@state", System.Data.DbType.String, state);
dbDatabase.AddInParameter(dbCommand, "@Ip", System.Data.DbType.String, Ip);
dbDatabase.AddInParameter(dbCommand, "@SaleNotes", System.Data.DbType.String, SaleNotes);
dbDatabase.AddInParameter(dbCommand, "@LeadStatus", System.Data.DbType.Int32, LeadStatus);
dbDatabase.AddInParameter(dbCommand, "@LastName", System.Data.DbType.String, LastName);
dbDatabase.AddInParameter(dbCommand, "@SourceOfPhotosID", System.Data.DbType.Int32, SourceOfPhotosID);
dbDatabase.AddInParameter(dbCommand, "@SourceOfDescriptionID", System.Data.DbType.Int32, SourceOfDescriptionID);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, CarID);
dbDatabase.AddInParameter(dbCommand, "@UId", System.Data.DbType.Int32, UId);
dbDatabase.AddInParameter(dbCommand, "@UserPackID", System.Data.DbType.Int32, UserPackID);
dbDatabase.AddInParameter(dbCommand, "@sellerID", System.Data.DbType.Int32, sellerID);
dbDatabase.AddInParameter(dbCommand, "@PostingID", System.Data.DbType.Int32, PostingID);
dbDatabase.AddInParameter(dbCommand, "@DispositionID", System.Data.DbType.Int32, DispositionID);
dbDatabase.AddInParameter(dbCommand, "@EmailExists", System.Data.DbType.Int32, EmailExists);
ds = dbDatabase.ExecuteDataSet(dbCommand);
return ds;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet USP_UpdateRegUserDetails(UserRegistrationInfo objUserregisInfo)
{
bool returnValue = false;
string spNameString = string.Empty;
DataSet dsUserInfo = new DataSet();
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_UpdateRegUserDetails";
DbCommand dbCommand = null;
try
{
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@UId", System.Data.DbType.Int32, objUserregisInfo.UId);
dbDatabase.AddInParameter(dbCommand, "@Name", System.Data.DbType.String, objUserregisInfo.Name);
dbDatabase.AddInParameter(dbCommand, "@PhoneNumber", System.Data.DbType.String, objUserregisInfo.PhoneNumber);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objUserregisInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objUserregisInfo.City);
dbDatabase.AddInParameter(dbCommand, "@Address", System.Data.DbType.String, objUserregisInfo.Address);
dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objUserregisInfo.Zip);
dsUserInfo = dbDatabase.ExecuteDataSet(dbCommand);
//blnSuccess = objUserLog.SaveUserLog(UserLogInfo, ref lngReturn, "");
return dsUserInfo;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Usp_Save_RegisterLogUser(UserRegistrationInfo objUserregisInfo, int EmailExists, string UserID)
{
bool returnValue = false;
string spNameString = string.Empty;
DataSet dsUserInfo = new DataSet();
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "Usp_Save_RegisterLogUser";
DbCommand dbCommand = null;
try
{
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@Name", System.Data.DbType.String, objUserregisInfo.Name);
dbDatabase.AddInParameter(dbCommand, "@UserName", System.Data.DbType.String, objUserregisInfo.UserName);
dbDatabase.AddInParameter(dbCommand, "@Pwd", System.Data.DbType.String, objUserregisInfo.Pwd);
dbDatabase.AddInParameter(dbCommand, "@PhoneNumber", System.Data.DbType.String, objUserregisInfo.PhoneNumber);
dbDatabase.AddInParameter(dbCommand, "@isActive", System.Data.DbType.Int32, 1);
dbDatabase.AddInParameter(dbCommand, "@CouponCode", System.Data.DbType.String, objUserregisInfo.CouponCode);
dbDatabase.AddInParameter(dbCommand, "@ReferCode", System.Data.DbType.String, objUserregisInfo.ReferCode);
dbDatabase.AddInParameter(dbCommand, "@PackageID", System.Data.DbType.Int32, objUserregisInfo.PackageID);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objUserregisInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objUserregisInfo.City);
dbDatabase.AddInParameter(dbCommand, "@Address", System.Data.DbType.String, objUserregisInfo.Address);
dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objUserregisInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@BusinessName", System.Data.DbType.String, objUserregisInfo.BusinessName);
dbDatabase.AddInParameter(dbCommand, "@AltEmail", System.Data.DbType.String, objUserregisInfo.AltEmail);
dbDatabase.AddInParameter(dbCommand, "@AltPhone", System.Data.DbType.String, objUserregisInfo.AltPhone);
dbDatabase.AddInParameter(dbCommand, "@EmailExists", System.Data.DbType.Int32, EmailExists);
dbDatabase.AddInParameter(dbCommand, "@UserID", System.Data.DbType.String, UserID);
dsUserInfo = dbDatabase.ExecuteDataSet(dbCommand);
//blnSuccess = objUserLog.SaveUserLog(UserLogInfo, ref lngReturn, "");
return dsUserInfo;
}
catch (Exception ex)
{
throw ex;
}
}
