// Create a candidate public int InsertCandidate(CandidateModel candidateModel) { int count = 0; SqlCommand cmd; Connection(); cmd = new SqlCommand("uspInsertCandidate", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@candidateId", candidateModel.CandidateId); cmd.Parameters.AddWithValue("@firstName", candidateModel.FirstName); cmd.Parameters.AddWithValue("@lastName", candidateModel.LastName); cmd.Parameters.AddWithValue("@manifesto", candidateModel.Manifesto); cmd.Parameters.AddWithValue("@imageUrl", candidateModel.ImageUrl); cmd.Parameters.AddWithValue("@previousHistory", candidateModel.PreviousHistory); cmd.Parameters.AddWithValue("@campaignId", candidateModel.CampaignId); cmd.Parameters.AddWithValue("@employeeId", candidateModel.EmployeeId); try { connection.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { message = ex.Message; } finally { connection.Close(); } return(count); }
private DataSet GetPreviousHistoryData(CandidateModel candidateModel) { DataSet ds = new DataSet("Histories"); DataTable dt = new DataTable("History"); DataRow row; dt.Columns.Add("Description"); ds.Tables.Add(dt); string history = candidateModel.PreviousHistory; row = dt.NewRow(); row["Description"] = history; dt.Rows.Add(row); ds.AcceptChanges(); return(ds); }