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