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