public int UploadArtworkInfo(SponseringDetails sponsoringdetails) { var sponsorId = Convert.ToInt32(Session["SponsorId"]); sponsoringdetails.SponserId = sponsorId; var result = _sponsorBO.UploadArtworkInfo(sponsoringdetails); return(result); }
//To save the uploaded artwork info public int UploadArtworkInfo(SponseringDetails sponseringDetails) { try { //sponseringDetails.SponserId = 1; //To save values to school Info table var result = _unitOfWork.Repository <SponseringDetails>().ExecuteProcedure("sp_sponsoringDetails_INSERT(@SponserId,@SchoolId,@Invoice,@Sport,@Season,@ItemsSponsering,@UploadArt,@Instructions)", new MySqlParameter("@SponserId", MySqlDbType.Int32) { Value = sponseringDetails.SponserId }, new MySqlParameter("@SchoolId", MySqlDbType.Int32) { Value = sponseringDetails.SchoolId }, new MySqlParameter("@Invoice", MySqlDbType.VarChar) { Value = sponseringDetails.Invoice }, new MySqlParameter("@Sport", MySqlDbType.Int32) { Value = sponseringDetails.Sport }, new MySqlParameter("@Season", MySqlDbType.Int32) { Value = sponseringDetails.Season }, new MySqlParameter("@ItemsSponsering", MySqlDbType.VarChar) { Value = sponseringDetails.ItemsSponsering }, new MySqlParameter("@UploadArt", MySqlDbType.Text) { Value = sponseringDetails.UploadArt }, new MySqlParameter("@Instructions", MySqlDbType.VarChar) { Value = sponseringDetails.Instructions } ); return(result); } catch (Exception) { throw; } }