public void tblSurveyDetail_Update(SurveyDetailDTO dt)
{
SqlCommand cmd = new SqlCommand("UPDATE tblSurveyDetail SET SurveyDate = @SurveyDate, SurveyId = @SurveyId, Description = @Description WHERE EmailId = @EmailId", ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@EmailId", SqlDbType.VarChar).Value = dt.EmailId;
cmd.Parameters.Add("@SurveyDate", SqlDbType.DateTime).Value = dt.SurveyDate;
cmd.Parameters.Add("@SurveyId", SqlDbType.Int).Value = dt.SurveyId;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void tblSurveyDetail_insert(SurveyDetailDTO dt)
{
string sql = "INSERT INTO tblSurveyDetail VALUES (@EmailId @SurveyDate @SurveyId @Description)";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@EmailId", SqlDbType.VarChar).Value = dt.EmailId;
cmd.Parameters.Add("@SurveyDate", SqlDbType.DateTime).Value = dt.SurveyDate;
cmd.Parameters.Add("@SurveyId", SqlDbType.Int).Value = dt.SurveyId;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void tblSurveyDetail_Update(SurveyDetailDTO dt)
{
sdDao.tblSurveyDetail_Update(dt);
}
public void tblSurveyDetail_insert(SurveyDetailDTO dt)
{
sdDao.tblSurveyDetail_insert(dt);
}
