public int addWorkshopOffer(RepresentativeAddWorkshopOffer obj,int repid)
{
string connectionString = Connstr();
int locid = 0;
if (obj.Location.CompareTo("Bangalore") == 0)
locid = 1;
else if (obj.Location.CompareTo("Delhi") == 0)
locid = 2;
else if (obj.Location.CompareTo("Kolkata") == 0)
locid = 3;
else if (obj.Location.CompareTo("Pune") == 0)
locid = 4;
else if (obj.Location.CompareTo("Jaipur") == 0)
locid = 5;
string staffStatus = "Pending";
string queryString = null;
queryString = "INSERT INTO WorkshopDetails(RepId,Domain,FromDate,ToDate,NoOfSeats,MinGradPct,MinPGPct,MinExperience,WorkshopDesc,LocationID,Location,StaffApproval) " +
"values(@rep,@domain,@from,@to,@seats,@mingrad,@minpost,@exp,@desc,@locid,@loc,@staff) ;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("@rep", repid);
command.Parameters.AddWithValue("@domain", obj.domain);
command.Parameters.AddWithValue("@from", obj.fromDate);
command.Parameters.AddWithValue("@to", obj.toDate);
command.Parameters.AddWithValue("@seats", obj.noOfSeats);
command.Parameters.AddWithValue("@mingrad", obj.GraduationPercentage);
command.Parameters.AddWithValue("@minpost", obj.PostGraduationPercentage);
command.Parameters.AddWithValue("@exp", obj.Experience);
command.Parameters.AddWithValue("@desc", obj.description);
command.Parameters.AddWithValue("@locid", locid);
command.Parameters.AddWithValue("@loc", obj.Location);
command.Parameters.AddWithValue("@staff", staffStatus);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return repid;
}
public ActionResult addWorkshopTODb(RepresentativeAddWorkshopOffer obj)
{
int id = (int)Session["UserID"];
int val = new DataAccess.RepresentativeDAL().addWorkshopOffer(obj, id);
return View("SuccessPage");
}
