public int saveSponsorInfo(SponsorInfoVM sponsorinfo)
{
sponsorinfo.SponsorName = sponsorinfo.FirstName + " " + sponsorinfo.LastName;
//To save values to User table
var data = _unitOfWork.Repository <Users>().ExecuteProcedure(" sp_users_INSERT(@UserName,@Password,@RoleId)",
new MySqlParameter("@UserName", MySqlDbType.VarChar)
{
Value = sponsorinfo.UserName
},
new MySqlParameter("@Password", MySqlDbType.VarChar)
{
Value = sponsorinfo.Password
},
new MySqlParameter("@RoleId", MySqlDbType.Int32)
{
Value = 3
});
var userId = _unitOfWork.Repository <Users>().GetAll().Where(f => (f.UserName == sponsorinfo.UserName) && f.RoleId == 3).FirstOrDefault().UserId;
//To save values to school Info table
var result = _unitOfWork.Repository <SponsorInfo>().ExecuteProcedure("sp_sponsors_INSERT(@SponsorName,@SponsorEmail,@SponsorAddress,@City,@State,@Zip,@BusinessName,@Phone,@AlternatePhone,@Fax,@BusinessWebsite,@UserId)",
new MySqlParameter("@SponsorName", MySqlDbType.VarChar)
{
Value = sponsorinfo.SponsorName
},
new MySqlParameter("@SponsorEmail", MySqlDbType.VarChar)
{
Value = sponsorinfo.SponsorEmail
},
new MySqlParameter("@SponsorAddress", MySqlDbType.VarChar)
{
Value = sponsorinfo.SponsorAddress
},
new MySqlParameter("@City", MySqlDbType.VarChar)
{
Value = sponsorinfo.City
},
new MySqlParameter("@State", MySqlDbType.Int32)
{
Value = sponsorinfo.State
},
new MySqlParameter("@Zip", MySqlDbType.VarChar)
{
Value = sponsorinfo.Zip
},
new MySqlParameter("@BusinessName", MySqlDbType.VarChar)
{
Value = sponsorinfo.BusinessName
},
new MySqlParameter("@Phone", MySqlDbType.VarChar)
{
Value = sponsorinfo.Phone
},
new MySqlParameter("@AlternatePhone", MySqlDbType.VarChar)
{
Value = sponsorinfo.AlternatePhone
},
new MySqlParameter("@Fax", MySqlDbType.VarChar)
{
Value = sponsorinfo.Fax
},
new MySqlParameter("@BusinessWebsite", MySqlDbType.VarChar)
{
Value = sponsorinfo.BusinessWebsite
},
new MySqlParameter("@UserId", MySqlDbType.Int32)
{
Value = userId
}
);
//To active the sponsor registered
var userDetails = _unitOfWork.Repository <Users>().GetAll().Where(f => f.UserId == userId).FirstOrDefault();
userDetails.IsActive = true;
_unitOfWork.Repository <Users>().Update(userDetails);
_unitOfWork.Save();
return(result);
}
public int SaveSponsorInfo(SponsorInfoVM sponsorinfo)
{
var result = _sponsorBO.saveSponsorInfo(sponsorinfo);
return(result);
}
