public int addTrainingOffer(RepresentativeAddTrainingOffer obj,int repid) { string connectionString = Connstr(); string queryString = null; 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"; queryString = "INSERT INTO TrainingDetails(TrainingID,RepId,CompanyName,Domain,Graduation,PG,PastExp,StartingDate,Duration,NoOfSeat,TrainingDesc,LocationID,Location,StaffApproval) " + "values(@train,@rep,@company,@domain,@grad,@post,@exp,@start,@duration,@seats,@desc,@locid,@loc,@staff) ;"; using (SqlConnection connection = new SqlConnection(connectionString)) { //Generate a six lettered random string SqlConnection connectionCheck = new SqlConnection(connectionString); String querycheck = "SELECT count(*) from TrainingDetails Where TrainingID=@trainid COLLATE Latin1_General_CS_AS;"; SqlCommand commandcheck = new SqlCommand(querycheck, connectionCheck); int checkExist = 1; string trainid=""; while (checkExist != 0) { trainid = RandomString(); commandcheck.Parameters.AddWithValue("@trainid", trainid); connectionCheck.Open(); checkExist = (int)commandcheck.ExecuteScalar(); connectionCheck.Close(); } SqlCommand command = new SqlCommand(queryString, connection); command.Parameters.AddWithValue("@train", trainid); command.Parameters.AddWithValue("@rep", repid); command.Parameters.AddWithValue("@company", obj.Company); command.Parameters.AddWithValue("@domain", obj.domain); command.Parameters.AddWithValue("@grad", obj.graduation); command.Parameters.AddWithValue("@post", obj.postGraduation); command.Parameters.AddWithValue("@exp", obj.Experience); command.Parameters.AddWithValue("@start", obj.startDate); command.Parameters.AddWithValue("@duration", obj.duration); command.Parameters.AddWithValue("@seats", obj.noOfSeats); 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 addTrainingTODb(RepresentativeAddTrainingOffer obj) { int id = (int)Session["UserID"]; string comp = (string)Session["UserName"]; obj.Company = comp; int val = new DataAccess.RepresentativeDAL().addTrainingOffer(obj, id); return View("SuccessPage"); }