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