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